Post reply

Renaming a file in SSIS

  • October 14, 2008 at 11:56 pm

    #127968

    I have a csv file in SSIS. I want to rename it as "FileName_2008_10_10.csv" and move it to a specified shared location.

    I tried using FTP System task but its giving error as its not able to identify the destination.

    Any suggestions how to go about it or any other way to do the same.

    Thanks

  • October 15, 2008 at 5:48 am

    #885127

    If the destination is on your network, you can use the file system task to move the file.

    I think if you rename the file and include the destination UNC filepath (i.e. \\servername\sharename\FileName_2008_10_10.csv) then the file gets renamed and moved in one step.

    Tom

    Life: it twists and turns like a twisty turny thing

  • October 15, 2008 at 5:52 am

    #885130

    I am able to manage it through script task.

    thanks so much.

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

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