execute sql task not triggering error constraint
I have an execute sql task - set to Delay validation on a table. I purposely changed the sql task to do a truncate table and listed an invalid table name.
The task turns red but does not follow the red line for the error processing. Why is the error constraint not working? All task share the same point of failure so the red line is a dotted line (or condition). Other errors are working fine.
Any thoughts?
My data flow task is not working as well. My first task is a file copy task and that errored out successfully, as I am testing the error process, and only the first step worked as designed. the other two task did not.
Also, I am executing the package not an individual task...
May 13th, 2011 1:17pm
Because you delayed the validation the error now occurs at runtime. What is the error message and constraint? What is the DFT? Preferably provide an image.Arthur My Blog
Free Windows Admin Tool Kit Click here and download it now
May 13th, 2011 2:01pm
I believe that you made something wrong. because I tried same scenario here and control flow redirected to Failure constraint successfully.
could you provide screen shots of your package schema and also execution schema?http://www.rad.pasfu.com
May 14th, 2011 1:24am


