Hi,
How can I dynamically change the file name in File connection Manager in SSIS package
I can do this in SQL 2000 but how to achieve the same thing in SQL 2005. I have to generate 10 different excel file and just need to change the file name in connection manager for excel file
Thanks
Shafiq
Change the File Name in File connection Manager
Eqbal Sajadi
Jamie,
Your article is good, but some how the expression tab of For Each loop does not have connectionstring property in the dropdown list.
I am using Excel Connection Manager for my files.
Please Guide
VK2ACP
You'll need to put an expression on the ConnectionString property of the flat file connection manager. Step 3 in here demos this: http://blogs.conchango.com/jamiethomson/archive/2005/05/30/1489.aspx
In fact, that whole post maps pretty well to what you seem to want to do.
-Jamie
mikebai
ConnectionString is a property of the Flat File Connection Manager. Not of the ForEach loop.
-Jamie