Forcing a task error for a SSIS 2005 pkg
Hi,
for a SSIS 2005 pkg I have an Execute SQL Task with two conditional constraints. When it is verified the 2nd condition I must raise a task error and so a pkg error.
How can I realize this behaviour, please? Thanks
January 27th, 2011 1:04pm
Hello,
In 2nd Condition Write
SELECT 1/0
that will raise error.
If you are looking for something different then please explain your requirement in detail.
ThanksAamir
Free Windows Admin Tool Kit Click here and download it now
January 27th, 2011 1:09pm
Ok. In an Execute SQL Task.
So I have tried to use a Script Task setting the task result to Failure. It functions for me.
Thanks
January 27th, 2011 1:14pm