Rename file extensions on FTP site

  • Hi

    We have a need to rename some *.tmp files to *.txt files on a suppliers FTP site and wanted to know if this is possible to do using a script task in SSIS?

    If so please can an example be provided

    Thanks

    Andy

  • You could do this in SSIS, but you're likely going to end up using a Script Task or executing a Powershell Script; making the entire point of putting it in SSIS somewhat pointless. There's no built in functionality in SSIS to loop through files on a remote FTP directory, such as with the ForEach Loop Contain. Personally I would likely do such task in Powershell.

    Thom~

    Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
    Larnu.uk

  • Hi Thom

    I also though about using PS however I have written very little in PS to achieve this

     

    Andy

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

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