ForEachLoop container? 1

[manmaria]

I have a sql task which takes tablename as a parameter and writes in a file with tablename as part of the file name. Unique table names can be available from a table. Right now I am generating one file at a time inputing the table name every time. Can I do this task using a Foreachloop container or something?

TIA

 

[LFCfan]

Yes, you can.

You can use a "SELECT TableName FROM ..." Sql Task to generate the result set as a Full Result Set, and pass thatthrough as a variable to the Foreach Loop container.

Within the container you can then call the Sql Task that takes the parameter and writes to the file, using the table name from the recordset as a parameter to pass to it.

Give me a few minutes and I'll dig out an article for you, with more information

~LFCfan

 

[LFCfan]

These should get you started.

http://decipherinfosys.wordpress.co...ed-sql-commands-using-the-execute-sql-task-i/

Foreach ADO Enumerator:

http://pragmaticworks.com/community.../12/19/ssis-for-each-ado-enumerator-loop.aspx

~LFCfan

 

[manmaria]

OK. Thanks. I will try.