June 19, 2008 at 1:57 am
I was familiar with the DTS object model and VB script but have little
experience with the new SSIS object model and VB.net.
(apologies for posting this on DTS forum first by mistake)
In a package there is some functionality by design that means sometimes a
Data Flow task will run and sometimes it won't.
After this point I wish to have a script task that checks to see whether
this task Data Flow task ran or not.
Is someone able to provide vb.net script to do this in the Script Task.
Paul R Williams.
June 19, 2008 at 5:18 am
You will save yourself a lot of headaches if you take another approach.
In the place in which you have the data flow task that is conditionally not run, set a variable - then check that variable for the conditional logic later. If the data flow task always has records, I would suggest using a rowcount transformation in the dataflow to set a variable, then check if your variable is zero later - figuring the actual number of rows may be of use.
June 19, 2008 at 7:25 am
I did actually think of using a variable to check if the task ran but I thought it would be a neater solution to just check to see if the task ran using the object model.
I'm not sure why it would cause headaches as it should not be a lot of code to check if the task ran. Unfortunately I can't seem to find any good documentation to using the object model with vb.net.
Paul R Williams.
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply