June 1, 2021 at 2:09 pm
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
June 1, 2021 at 2:27 pm
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
June 1, 2021 at 2:29 pm
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