Post a reply

Options
Add an Attachment

If you do not want to add an Attachment to your Post, please leave the Fields blank.

(maximum 10 MB; please compress large files; only common media, archive, text and programming file formats are allowed)

Options

Topic review

martin

Re: Automating winscp scripts using SSIS (parameters,variables)

See some examples.
Rahulgabraham

Automating winscp scripts using SSIS (parameters,variables)

Hi
I am using winscp scripts to read .dat files in a SFTP location and store it in my local system.

I am looking to automate this using SSIS.
The filename indicates the created date of file. For eg: filenames will be in the format xxx2000117 today and tommorow it will be xxx20100118.

How can I automate the scripts in such a way that I will be able to read only the current date's file today?

Is there any option for passing parameters into the scripts fromm SSIS? Or can it be done while scripting itself?