troubleshooting Question

SSIS: Fail 'Execute SQL Task' container based on returned result.

Avatar of Blowfelt82
Blowfelt82 asked on
Microsoft SQL Server 2008Microsoft SQL Server
4 Comments1 Solution368 ViewsLast Modified:
I have an SSIS package which has a 'Execute SQL Task' componenet. This task calls some SQL and returns 0 if everything is OK and 1 if an error has been found. This code is all working as expected. What I am looking for is a way to fail the component if the return code is > 0.

The 'Execute Process Task' has similar functionality where you can use the 'FailTaskIfReturnCodeIsNotSuccessValue' and 'SuccessValue' fields. I need the equivelent functionality for the 'Execute SQL Task'.
ASKER CERTIFIED SOLUTION
Alpesh Patel
Solution Architect at TCS (SAFe®Agilist, TOGAF® Foundation, PSM I®, MCP, MCSD)

Our community of experts have been thoroughly vetted for their expertise and industry experience.

Join our community to see this answer!
Unlock 1 Answer and 4 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 4 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros