SSIS and WINSCP

I need to automatically download files from SFTP and have been recommended winscp.

Using just scripting can I process error messages from winscp in SSIS so that I would know where ssis has failed?

If not is there any other way to report of failures from winscp via ssis?

Ideally I would want an email to a user to let them know that the task has failed.
LVL 6
CaptainGibletsAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Tony303Commented:
I run WinSCP in a Process task (I think, I'm not at work at the moment) in SSIS.
The parameters that I am using in WinSCP command line appends to a log.
Get onto the WinSCP website for the FAQ and find the commands.

I use SQL Agent to run my SSIS package. Normal emailing operator when the package fails has been good enough for me to know when the package has not worked.

Once you get the email, if it is a WinSCP problem then the last entry in the WinSCP log will tell you.
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
AlexPaceCommented:
I use Robo-FTP for SFTP in SSIS.  At first I experimented with setting the exitcode value on the EXIT command and using the WRITEFILE command to make a text file with the results but then I figured out how to use DBQUERY to run an insert statement so now I just write the SFTP result directly into a database table.
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft SQL Server

From novice to tech pro — start learning today.