Hi

How can I set the input file name at run time in SSIS for at bulk
insert task? In DTS I could set the filename using a Dynamic Properties
Task, and in that way specify the name, which in my case change
according to the date. But how do I do this in SSIS? I can set the
SourceConnection property using an Expression, but that specify an
existing connection and not the filename for that connection.

Thanks in advance.

-Henrik.

Hi

The answer is (of cource) to set the property on the Connection used by
the Bulk insert task.

-Henrik.