Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums  SQL Server 2005 Forums  SSIS and Import/Export (2005)  SQL Job fails when process Task fails

Author  Topic  sotn100 Starting Member 1 Post Posted - 2010-02-02 : 12:36:44 I have a process task which may fail as it contains connection parameters and the username may be wrong for example so this is handled by a failure work flow to record failure messages etc. When I run through VS2005 then the job completes. When I run this as a step in a SQL Agent Job, it performs the tasks after the process task but the job itself is reported as Failed. It returns, the message, The process exit code was "1" while the expected was "0". End Error DTExec: The package execution returned DTSER_FAILURE (1) How do I stop this 'expected' error from telling SQL Agent that the whole package failed whilst still performing different workflow on the fail? I mean I cannot force a success as I need to perform different subsequent tasks if success or failed