Home Forums SQL Server 2005 SQL Server 2005 Integration Services File Archive Question in SSIS RE: File Archive Question in SSIS
Raunak Jhawar
SSCoach
Points: 15701
More actions
October 15, 2013 at 12:42 am
#1658406
As Phil has already answered, there is an option called as "IsSourceConnectionVariable", set this as true and assign the variable name as the one holding the file name.
Here is a good resource:
http://www.bidn.com/blogs/KeithHyer/bidn-blog/2465/copy-and-rename-a-file-in-ssis-using-the-file-system-task
Raunak J