Change the File Name in File connection Manager

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

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

|||

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

|||

ConnectionString is a property of the Flat File Connection Manager. Not of the ForEach loop.

-Jamie