November 9, 2010 at 2:06 am
How do I dump a table from an object variable into a flat txt file using SSIS 2008. Without using script task/component.
November 9, 2010 at 2:22 am
siamak.s16 (11/9/2010)
How do I dump a table from an object variable into a flat txt file using SSIS 2008.
What you mean dump a table from an object variable.?
Can you please explain
November 9, 2010 at 2:26 am
I have an Execute SQL Task that runs a query and saves the result set in a variable of Type Object.
I need to get that information from that variable and put it in a comma separated text file.
November 9, 2010 at 2:55 am
Not sure how you can get around using a script task in a dataflow. You can use the script as a source component to output the table into the dataflow and then use a flat file destination.
With that said, why are you doing the query in an Exec SQL Task instead of in the dataflow itself?
CEWII
November 9, 2010 at 10:26 am
Never mind, the requirements just changed. I can use script component now.
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply