In a project I have created 6 dtsx packages, all doing about the same thing:
sql task defines highest date in database and store in variable
script task to create an oracle sql statement based on the above date
dataflow task to
1.select from oracle, taking the select from variable above
2.do some data conversion (numeric --> int),
3.store in sql server table
run sp to add or update from tmp table to main table
Run one by one the packages execute perfectly.
In the same project I made a package "run all" and for each package I make a
execute package task.
When selecting execute task: This fails miserably, always at the third
package dataflow task, with the complaint that:
The external metadata column collection is out of synchronization (lot of
column names)
and
The column "ADD_ID_POSTAL_ADDRESS" needs to be added to the external
metadata column collection (a lot of these, one for each field).
The fields that I see in the progress tab are fields in the table of a
previous task within the package.
Any suggestions? Overlooking something?
Thank you
Jos
>> Stay informed about: execute package of a number of execute package tasks