Stack Overflow
Stack Overflow

Questions tagged [dataflowtask]

113 questions
0
votes
1 answer

Using Multiple Sources in SSIS Data Flow Task

For my data flow task I have a OLEDB Source. In the SQL command section of this I have compiled a select query based on tables from two different databases, held on the same instance. Every time I run this it errors, but when I moved the tables to…
JYatesDBA
  • 25
  • 1
  • 10
0
votes
2 answers

SSIS - How to Insert from Flat File to OLE DB with date range?

I have a flat file source with columns that have start and end dates per row, and the table I am attempting to insert into only has one date column, which means I have to insert 1 row per week from the start date until the end date. Sample FF…
John M.
  • 51
  • 1
  • 3
0
votes
0 answers

SSIS output error when there are no records on Data Flow Task

I'm querying records from an IBM DB2 database. If there are records, the data flow task runs fine, when there are no records I get this error: [SSIS.Pipeline] Error: SSIS Error Code DTS_E_PRIMEOUTPUTFAILED. The PrimeOutput method on ODBC Source…
Russtopher
  • 123
  • 1
  • 4
  • 12
0
votes
0 answers

SSIS Pre-Execute phase in DataFlow Task

I have an SSIS package with one DF task. Oledb source is oracle and Oledb destination is SqlServer, no transformations in between.The query used to pull data from source is Select a.col1,a.col2,c.col1,c.col2 from table a join table b on a.id = b.id…
sab
  • 338
  • 1
  • 3
  • 21
0
votes
1 answer

SSIS Sort task (data flow)

I have a package where I am sorting by Aged Months column, I am not doing any other thing to filter the data and I am not removing duplicates, but once the data flow passes the Sort task the output rows are much less than the input. (1.218.206 rows…
Rachel
  • 208
  • 1
  • 5
  • 18
0
votes
0 answers

Data Flow Task is no longer available in Visual Studio 2012 Project

I've worked on an SSIS project in Visual Studio 2012 for a while. Recently, when I tried to modify it, the following error message shown on a "Data Flow Task": "The task has failed to load". And I cannot find "Data Flow Task" item in SSIS Toolbox.…
Jay
  • 65
  • 1
  • 9
0
votes
1 answer

Issue while loading float columns to destination table through SSIS

I have a situation where in source table, there are 4 columns having data type float. When I created new destination table with same schema (having data type float only) the values are loading as 0. This does not happen when I transfer data manually…
Avineshkumar Tiwari
  • 89
  • 7
0
votes
1 answer

Dealing with sources with dynamic column name in Dataflowtask

I should read data from a source, which its column name changes permanently(column name is date): I would like to write it in a table, I have such a mapping: Of course if the column name is changed, by next run, it doesn't work anymore. Do you…
Kaja
  • 2,962
  • 18
  • 63
  • 99
0
votes
1 answer

SSIS set priorities from many tasks to one

This is the scenario: The first task check the presence of some files, write variables and with expressions check which data flow task run. And here everything works. I would like to have the last task turned on when all of the previous tasks have…
Andryx93
  • 81
  • 1
  • 8
0
votes
1 answer

Why is > conditional split in SSIS package returning >= result? update: (DateTime != DT_DBTIMESTAMP ?!)

I have an SSIS data flow conditional split transformation that is returning a >= result when it should be returning a > result. From the beginning... My SSIS package executes a SQL task that stores a max(date) from one table in variable…
Neil
  • 2,316
  • 1
  • 22
  • 26
0
votes
2 answers

SSIS Cannot convert between unicode and non unicode...but it's not true, how come?

I have a simple DTSX that takes in some data, and write it to a SQL server DB, on this DTSX execution it throws me some errors on some fields: [OLE DB Destination [29]] Error: Column "mobile" cannot convert between unicode and non-unicode string…
FabioEnne
  • 732
  • 1
  • 14
  • 43
0
votes
1 answer

dataflowQueues processing or pipelines only seems to be triggered on df.val request

Looking at Gpars dataflows/pipelines but there is something I don't understand If you look at the example below (I've done this with operators, piplines, chainWith, and hit the same problem). In this example I've used tasks but could just as easily…
WILLIAM WOODMAN
  • 1,185
  • 5
  • 19
  • 36
0
votes
1 answer

generating flat files for different sql files in single SSIS package

I have a folder which contains different SQL files. Now in the SSIS package, in foreach loop, I'm reading the query stored in each sql files (with script task) and later executing the query in the Execute script task and thus getting a resultset in…
Asin
  • 63
  • 1
  • 9
0
votes
0 answers

SSIS + ADO.NET + oracle source + sql server destination + intermittent missing data

I've been reading data from oracle to sql server using Data Flow Tasks, its been working but there are times that no data would be returned. However when I run the query in oracle plsql developer, I can see data or preview the results in source…
arzman
  • 1
0
votes
0 answers

Parallel Data Flow Task in SSIS

I am facing a problem for data flow task for parallel execution to insert rows into a single table e.g TABLE_DESTINATION from a source Table e.g TABLE_SOURCE.I do not directly insert the row into the table "TABLE_DESTINATION" . I use a stored…
Supriyo Bhattacherjee
  • 547
  • 1
  • 5
  • 26
1 2 3 4 5
6
7 8