October 14, 2005 at 3:29 pm
I have a dts package with a looping structure that includes a bulk insert task.
Occasionally I get a bad file and the bulk insert fails
There is a on failure branch for the Bulk Insert task but when it fails the packages ends with a failure and it does not takke the failure path and execute the next steps.
I have recreated the package but it still will not take the fail path.
Any ideas?
October 17, 2005 at 8:00 am
This was removed by the editor as SPAM
October 17, 2005 at 10:39 am
Robert,
Right-click on the Bulk Insert task, select workflow, then workflow properties. On the Options tab, make sure the checkbox for Fail package on step failure is cleared. Also, on the Logging tab of Package Properties, make sure the checkbox for Fail package on first error is cleared.
Greg
Greg
October 17, 2005 at 10:40 am
More information required.
By looping, are you referring to an activex script that checks and executes previous steps etc...
???
October 17, 2005 at 10:57 am
Yes, the looping is the activex that continues the process untill all the files in the directory are processed
The Fail Flag on the logging tab was indeed the issue. I cleared this flag and the load failure path was executed and the process continued as designed - THANK YOU
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply