June 10, 2011 at 7:26 am
Hello,
I have 6 different packages.
In these,
3 packages are primary packages because it's related to primary key.
So i have to load 3 package first.
And Remaing 3 packages is foreign key reference tables (to primary tables).
They are all seperate packages.
How can i know, like first 3 packages loaded successfully??
IF they are loaded successfully then how can first 3 packages(primary packages )call other 3 packages(foreign key packages)?
Thanks
L
June 10, 2011 at 8:17 am
This was removed by the editor as SPAM
June 10, 2011 at 9:36 am
One of many ways:
A package can have execute package tasks within the control flow. So if you have your "primary" package loading the data with the PK, it can call a package for each "child" table (or if you prefer just use additional data flow tasks downstream from the first).
Set the first data flow, which loads the "primary" data, to "fail package on failure", this way if your initial insert fails the additional "child" load won't run.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply