Hi,
I have an issue with running a DTS job from the command line and would be grateful for any advice that you might have. I have a DTS job that calls another DTS job from within it. If I run it in design mode it finishes OK. If I run it from the command line it runs through to the end - the screen says it was sucessful but it doesn't return to the command prompt. Both DTS tasks ar a mixture of connections data pumps and activex scripts. Have you ever heard of this?
Thanks,
Tom
I have an issue with running a DTS job from the command line and would be grateful for any advice that you might have. I have a DTS job that calls another DTS job from within it. If I run it in design mode it finishes OK. If I run it from the command line it runs through to the end - the screen says it was sucessful but it doesn't return to the command prompt. Both DTS tasks ar a mixture of connections data pumps and activex scripts. Have you ever heard of this?
Thanks,
Tom