Groups | Blog | Home
all groups > sql server dts > may 2006 >

sql server dts : DTS within DTS scheduled job problem


caroline.howe NO[at]SPAM equitant.com
5/29/2006 9:46:50 AM
Hi all,

I'm having a problem with my DTS packages when they are run as
scheduled jobs.
Basically, I have a DTS that calls other DTS packages from within. When
run through enterprise manager, it all runs fine, all internal DTS
packages are called and run successfully.
However, when I set up and run the DTS as a scheduled job, the job
itself looks as though it has run successfully, however none of the
internal packages (that should be called within) are called.
I have set these DTS packages up to run using the local system account.
No errors are being returned.
Can anyone please explain how this can happen? And how can I resolve
this?

Thanks,
Caroline.
caroline.howe NO[at]SPAM equitant.com
5/29/2006 9:47:59 AM
oh, and apologies, I'm running this on SQL Server 2000 with SP3a.
Allan Mitchell
5/30/2006 12:55:21 AM
Hello caroline.howe@equitant.com,

In 99% of the cases where this happens it usually has something to do with
this article.

Remember that DTS is a client and running from EM on your Box is not the
same as doing it on the server even though you may retrieve the package from
"local Packages" on the server

http://support.microsoft.com/?kbid=269074

Allan Mitchell
www.SQLDTS.com
www.SQLIS.com
www.Konesans.com

[quoted text, click to view]

caroline.howe NO[at]SPAM equitant.com
5/30/2006 1:47:37 AM
Thanks for this Allan - I've changed the ownership of the scheduled job
to the 'sa' login and have scheduled it to run tomorrow morning (has to
be done out of hours!). Hopefully, this should resolve the issue.
Thanks very much for your direction,
Caroline.
AddThis Social Bookmark Button