For Each Loop around Execute Process Task that uses WinSCP to get a file

Question

For Each Loop around Execute Process Task that uses WinSCP to get a file

KoldCoffee

SSCoach

Points: 18971
More actions
January 3, 2015 at 9:42 pm

#302182

I have an Execute Process Task that uses this tutorial to get the job of getting a file from a remote server dropped into a local folder.
http://winscp.net/eng/docs/guide_ssis
Next I want to pull this Execute Process Task inside a For Each Loop container because there are multiple (30) files with format YYYY-MM-DD*.txt.zip and I need to automate the getting of all (not just one) of them.
Does anyone know of a good tutorial for using For Each to get multiple files from a remote ftp location?

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

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

Eirikur Eiriksson SSC Guru Points: 182911 More actions · Answer 1

KoldCoffee (1/3/2015)
I have an Execute Process Task that uses this tutorial to get the job of getting a file from a remote server dropped into a local folder.
http://winscp.net/eng/docs/guide_ssis
Next I want to pull this Execute Process Task inside a For Each Loop container because there are multiple (30) files with format YYYY-MM-DD*.txt.zip and I need to automate the getting of all (not just one) of them.
Does anyone know of a good tutorial for using For Each to get multiple files from a remote ftp location?

Quick questions:

1. Are there many remote locations or is there only one (for each SSIS package)?

2. Is the local directory emptied after processing the files?

Simple suggestion, WinSCP has an option called synchronize, simply set up / configure a session for each combination of local-remote locations, from SSIS open the session and call the synchronize command.

😎

KoldCoffee SSCoach Points: 18971 More actions · Answer 2

1. Are there many remote locations or is there only one (for each SSIS package)?
2. Is the local directory emptied after processing the files?

Answers:

1: one remote location for the SSIS package

2. yes, the local directory is emptied.

Question regarding suggestion. Does synchronize get used on the command line of the Execute Process Task, meaning I won't need to use a for each loop container for the getting of the remote files into the local folder?

Eirikur Eiriksson SSC Guru Points: 182911 More actions · Answer 3

KoldCoffee (1/4/2015)
1. Are there many remote locations or is there only one (for each SSIS package)?
2. Is the local directory emptied after processing the files?
Answers:
1: one remote location for the SSIS package
2. yes, the local directory is emptied.
Question regarding suggestion. Does synchronize get used on the command line of the Execute Process Task, meaning I won't need to use a for each loop container for the getting of the remote files into the local folder?

That is correct, no looping needed, cannot recall how I did the transfer logging though.

😎