Multiple-step OLE DB operation generated errors.
Hello,
i am gett in the following error
"Multiple-step OLE DB operation generated errors.
Check each OLE DB status value, if available. No work was done."
i have two DTS's. i am calling one from the other. in the calling DTS i have one SQL server connexion which i am using for some sql tasks. the other DTS is being called as a task and is run using dtsrun.
the nested DTS has one SQL server Connection. which i am using for two tranform tasks, simultaenously.
this is the third task in the inner dts.
sometimes Batch fails in the inner DTS with the error i have given
|