March 18, 2005 at 7:12 am
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?
March 18, 2005 at 11:49 am
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]
March 18, 2005 at 12:06 pm
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!
March 18, 2005 at 12:07 pm
It really is cumbersome and is why we're all eagerly awaiting Yukon/2005 and SSIS to replace DTS.
Viewing 4 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy