Stack Overflow
Stack Overflow

Questions tagged [ssis-data-flow]

Tag for questions involving the SSIS Data Flow Task

This tag is for questions about the SSIS Data Flow Task. This task

encapsulates the data flow engine that moves data between sources and destinations, and lets the user transform, clean, and modify data as it is moved. Addition of a Data Flow task to a package control flow makes it possible for the package to extract, transform, and load data.

This tag should not be used for general questions on the concept of data flows (use the tag), or for TPL Data Flow (use the tag).

16 questions
2
votes
2 answers

Mapping Output Parameters in SSIS OLE DB Source Editor

How can i map output parameter in OLEDB Soruce SSIS(BIDS 2008).In (BIDS 2012) we can specify the query parameter as input and output. SET FMTONLY OFF; EXEC [dbo].[ProcessPingErrorAlert_KeyValue] @AlterId = ?, @Hour = ?, @Day = ?, @TraceId =…
Moeen Ali
  • 21
  • 1
  • 3
1
vote
4 answers

Viewing Results which are not Output to a Destination

When developing a Data Flow I don't always want to output the results to a destination - but I would like to see the data. Is there a way to attach a Data viewer to an output without having to have a destination? The file and raw destination have…
Mesh
  • 6,262
  • 5
  • 34
  • 53
1
vote
2 answers

SSIS Excel Destination Editor closes unexpectedly

I'm fairly new to SSIS, but what I'm trying to do should be simple: I have a Data Flow task that has an OLE DB Source feeding into an Excel Destination. The issue though, is I can't configure the Excel Destination correctly. I'm able to connect my…
JacobD
  • 75
  • 9
1
vote
1 answer

Oracle query in SSIS defines wrong data types

I have a somewhat complex query that I want to use as a source in an SSIS package. I create my OLE DB Source, specify the access mode as SQL, and paste my query in the command textbox. When I click Preview, sample data comes back and everything…
King User
  • 100
  • 6
1
vote
3 answers

Best practice to organize a 200+ tables import project

This question is going to be a purely organizational question about SSIS project best practice for medium sized imports. So I have source database which is continuously being enriched with new data. Then I have a staging database in which I…
Ucodia
  • 7,410
  • 11
  • 47
  • 81
0
votes
0 answers

Use ISDATE() function in MySQL to check plausibility of records

I want to control which records have no date format. I used isdate for this but i get a syntax error. Does anyone know how I can check whether data records have been saved correctly as dates. select ISDATE(EINBAUJAHR) as Datum from GAS_ARMATUR; I…
Arash_hokm
  • 1
  • 1
0
votes
1 answer

SSIS Consolidate huge amount of data - suggestion

I need to consolidate data from 30 databases and 20 tables. My first attempt was to create one data flow for each table. Each data flow would have 30 db sources which takes data from 1 table from each db and then inserts in 1 destination. This…
ilija veselica
  • 9,414
  • 39
  • 93
  • 147
0
votes
0 answers

Extract data from the Object into DataTable using Script Component in SSIS Data Flow Task

I'm looking for a way to use the Script Component (as Source) in SSIS dataflow task to output a table generated from a Object data type. Below is what I tried My Script Component properties My Script public class ScriptMain : UserComponent { …
MJoy
  • 1,349
  • 2
  • 9
  • 23
0
votes
2 answers

SSIS - Dataflow Destination Validation Before Insert

I am using data flow to send data between different DB servers and I do not have a joined server. I need to validate the data with a stored procedure before insert the data from OLE DB source into the destination. May I know is there any way can…
Noobie
  • 37
  • 1
  • 7
0
votes
1 answer

SSIS Data Flow Conversion of Float to NVarchar importing null values

I am trying to import an Excel 2007 spreadsheet into a staging table and I am encountering issues with some of the column types. Some of my columns have a combination of numeric and text values i.e. A column called Customer No can have numeric…
user745844
  • 23
  • 2
  • 6
0
votes
0 answers

Will the order of the data be retained from OLE DB Source to OLE DB Destination?

In an SSIS package, I have a data flow task that contains an OLE DB Source and an OLE DB Destination. The OLE DB Source is set to SQL command and has a query similar to the following: SELECT * FROM SomeTable ORDER BY Col1, Col2 Will the insertion…
Kevin Ganancial
  • 37
  • 7
0
votes
1 answer

Perform data conversion transformation in a SSIS DFT inside Foreach Loop Container

I have got around 35 tables whose data need to be migrated from SQL Server to MySQL. I am using SSIS for this project and I have set up a control flow (using Load Multiple Tables) with a Script Task and a Foreach Loop Container that iterates through…
PratikGandhi
  • 79
  • 11
0
votes
1 answer

Dynamic Columns Names in Excel Destination (data flow)

I'm trying to make my 'destination column' dynamic in an Excel Destination. The data inserted into the columns is always the same aswell as the amount and position of the columns. The reason for this is because my headers are multi-language. However…
Alim
  • 227
  • 1
  • 4
  • 18
0
votes
1 answer

SSIS component DLL Deployment

I've developed a custom SSIS DataDlow component. Now it's time to deploy the DLL. In my work and test environment I've simply registered the DLL in the GAC and coped it into: "C:\Program Files (x86)\Microsoft SQL…
Alberto Geniola
  • 15
  • 4
0
votes
0 answers

The timing of an SSIS Data Flow Commit

I am using an SSIS dataflow to copy data from a source table "s" to a target table "t", which is empty. For the very next step after the dataflow, I have a "Exec SQL Script" that runs a delete statement that deletes from a table "z" where the…
user2859231
  • 11
  • 3
1
2