File Archive Question in SSIS

• rocky_498

  SSCertifiable

  Points: 6532

  More actions

  October 14, 2013 at 3:27 pm

  #299187

  Hi guys,

  Here is my question, I have to archive every day file. I know I can use

  File System Task to transfer file from one folder to other. Here is the problem

  File Name always different, here is the e.g (FileName_getdate), so filename

  always gonna same_Date when package runs. Is anyone can guide me...

  Thanks in advance.

• Phil Parkin

  SSC Guru

  Points: 247158

  More actions

  October 15, 2013 at 12:17 am

  #1658403

  If you've processed a file with a dynamic name, you must already have the file name in a variable. Use that in the FST.

  ---

• 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