Post reply

File Archive Question in SSIS

  • 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.

  • 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.

    If you haven't even tried to resolve your issue, please don't expect the hard-working volunteers here to waste their time providing links to answers which you could easily have found yourself.

  • 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

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply