April 25, 2006 at 9:07 am
Have a DTS package calling another DTS Package with the Execute Package Task object.
Last night, one of the tables I was loading in the child DTS package didn't load...got an error.
The parent DTS package kept running and didn't show an error.
Any ideas?
April 25, 2006 at 9:30 am
You probably need to add troubleshooting code to the packages and maybe implement some logging.
Regards,Yelena Varsha
April 25, 2006 at 9:32 am
Did the child package actually fail? If it continued running and completed successfully, the parent package would complete successfully. You might try setting the 'Fail package on first error' property on in the child package.
Package Properties --> Logging --> Fail package... checkbox
Greg
Greg
April 25, 2006 at 9:45 am
Well, I purposely don't "fail package on first error" on the child because I'm loading several tables in parallel. I want the other tables to load. When I run something like this independently, the job usually notifies me of an error when one of the tables doesn't load.
The parent DTS is using a workflow with the child executing in the middle.
Drop Indexes -> Execute Package -> Create Indexes
I guess it is working differently because I have a job calling DTS which calls another DTS. I guess my real problem is my job didn't show a failure and notify me.
April 25, 2006 at 10:50 am
I think you're stuck with trying to passing a global variable indicating success or failure from the child package to the parent package. See Robert Marda's reply in this thread: http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=19&messageid=17214 . I've also seen an article about this on SQLDTS.com.
Greg
Greg
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply