Bypass or Skip Step in DTS Package
-
Hello, I have what is surely a common need, I have a package with say 5 steps, the 3rd step is a transformation from a text file to a table, and what I need to do, is if the file is empty or has data, I want to complete the remaining steps in the package, but if it is empty (0 kb), then simply skip the transformation, but continue on with the remaining two steps. I have accomplished this by inserting an activex script to check if the file exists and if it is of length 0 kb, if so I am disabling the following step, and setting the precedence constraints on the subsequent steps. It works fine, but it seems rather complicated to do this and I would think there would be an easier way (no laughing now). Any ideas out there?
-
That is exactly how I do it, but to make the coding really fast and easy, just write your precedence basis and value to globals. Then move from the active x to a dynamic properties task, and set the precedence basis and value of the desired step(s) to the globals.
[font="Courier New"]ZenDada[/font]
-
Thanks for the info Jules, I plan to make this a little more generic for use in other packages, it just seemed so cumbersome for something that would be so common (hence the post). Thanks again!
-
It really is cumbersome and is why we're all eagerly awaiting Yukon/2005 and SSIS to replace DTS.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply