Post reply

Archive the source file having different Name

  • August 4, 2010 at 8:43 am

    #140123

    Hi i have source file comes every hour with date,time and i want to archive these files into a folder. how it can be done in SSIS. I know how to do with constant file name. i dont know how to do it for dynamic source file name. here is the format that get for source files

    2010-08-04 16.25.43.447

    2010-08-04-15.15.43.488

    Thanks

  • August 4, 2010 at 10:41 am

    #1202202

    I believe you are using For Each loop to loop through the files.. So all you need to do is

    1. Extract part of the FileName from the Filepath using Substring Function and store in a variable

    2. In another variable Define the Archive path and add the 1st variable that will have the FileName..

    So now will have Archivepath and FileName.. you can use a FILE system task to move the file..by selecting the Source and destination as variables.. Place this task in the FEL below the DFT

  • August 4, 2010 at 4:00 pm

    #1202422

    it worked for me.. Thanks Divyanth

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

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