SSIS Task

Last Post 23 Jun 2011 05:49 AM by dbandee. 2 Replies.
AddThis - Bookmarking and Sharing Button
Author Messages Not Resolved
dbandee
New Member
New Member

--
22 Jun 2011 05:30 AM
Good morning
I have SSIS that ftps files over and we process the files.
When files are not ar the ftp site the FTP task fails. On failure i have it go to script task to log error and thats it.
However ssis still reports failure
My question is: in FTP task how do i force it to report success even if it fails?

thank you
russellb
New Member
New Member

--
22 Jun 2011 05:58 AM
If you're running it from a SQL Agent job, have the step "quit reporting success"
dbandee
New Member
New Member

--
23 Jun 2011 05:49 AM
I am running it from sql job. because this ssis has a few more steps processing data after files are downloaded.

if it fails after ftp was successful, for example inserting data into a table, i will not know because the job will report success.

i cant find much online about ssis ftp task and how to handle it.

your help is appreciated

thanks


Acceptable Use Policy
---