Post reply

Transfer file into Archive folder

  • March 28, 2013 at 11:51 pm

    #291602

    Hi All,

    I am having text file as a source, I want to load data from this comma separated text file to Sqlserver Table. If all Data loads sucsessfully then I want to transfer this file into another folder or location as next day fresh file will come by same name on that location. Please help.

    Thanks

    Abhas.

  • March 29, 2013 at 1:02 am

    #1601940

    Use File System Task, it performs operations on files and directories in the file system. By using the File System task, a package can create, move, or delete directories and files. You can also use the File System task to set attributes on files and directories.

  • April 2, 2013 at 12:39 pm

    #1602931

    Above is the preferred method, but you could also use a PowerShell script to archive if you have more familiarity using that.

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

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