Transfer file into Archive folder

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

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

  • 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