In a job I am loading data from one ODBC.
I have a trnsformer with two output links connecting to ODBC stages OD1 and OD2.
I want to load the data in OD1 first and then in the OD2 (constraints are in transformer)
Is there any functionality for sequencing the loading of target stages ?
Yes, you can set the sequence of passing the data to the output links.
Open your transformer, and go to the properties, go to Link Ordering tab within the Stage tab. There you can specify the ordering.
Success consists of getting up just one more time than you fall.
Amar_nath wrote:Yes, after loading of OD1 is completed then only OD2 's loading should be started .
In that case you would need to split your job into two jobs called from within a sequence job,
first job would be for populating the OD1.
and on the sucessful completion of the first job, second job should populate the OD2.
Success consists of getting up just one more time than you fall.
I am always in favor of having separate jobs to load two database stages. Becomes easier, for example if the second load fails for some reason, just rerun it. But, with your design... I dunno!!!