Link to home
Start Free TrialLog in
Avatar of jvoconnell
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.
ASKER CERTIFIED SOLUTION
Avatar of Raja Jegan R
Raja Jegan R
Flag of India image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of jvoconnell
jvoconnell

ASKER

This is very helpful. Thank you for your time!!!
Welcome, glad to assist!!