errors but finished with success

My ssis package errors out because one of the database connection failed. I successfully logged error but also indicated that package finished successfully. My confusion is if a sheduling software schedules this package, what would be return code sent by dtexe... . would it be success or failure? In this scnerio i want it to return failure so that appropriate team can be contacted.

thanks,

kushpaw

Hi Kushpaw,

There is a property on the tasks in the control flow entitled FailPackageOnFailure. If you set this to true on the tasks that fail then the entire package will fail. The returned value should reflect this.

Hope this helps,

Grant