jvoconnell
asked on
Execute SQL task stored procedure not failing in SSIS
Experts,
I have an SSIS package that has an Execute SQL task that runs a stored procedure. The package was hanging. I figured out the proc has an error. If I execute the task manually in SSIS it does in fact fail the task. But if I execute the entire package it will just hang on that task. Just for speed I created a proc that simply divides by zero so it will fail instantly. I've tried it without a Try/Catch. I've tried with a Try/Catch with a "THROW" and a Try/Catch with a RAISEERROR but the package will not fail.
Any insight is appreciated. We are using VS2010.
I have an SSIS package that has an Execute SQL task that runs a stored procedure. The package was hanging. I figured out the proc has an error. If I execute the task manually in SSIS it does in fact fail the task. But if I execute the entire package it will just hang on that task. Just for speed I created a proc that simply divides by zero so it will fail instantly. I've tried it without a Try/Catch. I've tried with a Try/Catch with a "THROW" and a Try/Catch with a RAISEERROR but the package will not fail.
Any insight is appreciated. We are using VS2010.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Welcome, glad to assist!!
ASKER