May 6, 2003 at 12:52 am
Is there anything inherently wrong with the following programmatic setup:
A SQL job running a DTS package that runs a VB program that runs a DTS package? In our program, the VB program does the work of looping thru some input folders looking for files to load, so it may/will call the last DTS package many times in a row.
We are having problems with the job hanging and not advancing to the next job step. Related to this post:
THANKS
May 6, 2003 at 4:11 am
Have you tried truning logging on in your DTS packages to see if maybe you can find where they issue is occurring. Also, with the intermediary VB app I would add some log writting code if you have the source, it may be lookin for a folder or something that is gone or is locked in some way but without being able to look inside the steps your problem may be hidden from you.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply