Passing Full Result set to Data Flow Task SSIS

sql ssis oledb execute flow
user2639615 picture user2639615 · Dec 29, 2013 · Viewed 14.3k times · Source

The Proc inside Execute Sql Task returns Start and End date, I stored those values as full result set on an object variable. Now I need to pass that result set (start and end date) to a data flow task. inside data flow I will extract data from oledb source based on that start and end date and save the result to a text file

So my question is how to pass the start and end date to a data flow task ,

The start and end date return in execute sql task, that i need to pass as parameter inside dataflow task (select ... from table where created date between start date and end date)

Answer

gannaway picture gannaway · Dec 30, 2013

If you are just getting a single start and end date, you could just map those to separate variables instead of storing the full result set as an object variable (change full result set to single row and map accordingly).

However, if you must work with a full result set you can setup a for each loop and then extract the start and end date into SSIS variables (which can then be used in a data flow):

enter image description here

enter image description here

enter image description here

Related questions

SSIS OLEDB destination with SQL command

I have a simple SSIS package with a data flow task with ADO.NET source & destination: Normally, I would just select 'table or view' on the OLEDB destination, but although the connection is correct it's not showing me any …

Read More
How to pass variable as a parameter in Execute SQL Task SSIS?

I have ssis package in that I'm taking values from flat file and insert it into table. I have taken one Execute SQL Task in that creating one temptable CREATE TABLE [tempdb].dbo.##temptable ( date datetime, companyname nvarchar(50), price decimal(10,0), …

Read More
Text was truncated or one or more characters had no match in the target code page including the primary key in an unpivot

I'm trying to import a flat file into an oledb target sql server database. here's the field that's giving me trouble: here are the properties of that flat file connection, specifically the field: here's the error message: [Source - 18942979103_txt [424]] …

Read More