Firstly I'd warn you that DTS is ugly and picky and illogical. Secondly, have you tried running it manually from multiple machines? I think you'll find it doesn't work. When you run it manually through EM, it runs it on your machine, not on the server (as best I understand it). But when you run it on the server, it may not have database registrations with the same names etc as on your machine, so it fails when it tries to connect to them.
I'd advise either constructing the DTS package from the same physical machine that SQL runs on, or setting up registrations with the same details on the SQL machine as on your local machine. Otherwise testing is tricky. David -- David Cummins Systems Developer Ubiquity Software Ltd. Ph: (09) 309-1921 Steven Dworman wrote: > > Here's the deal. We have a DTS package that needs to be executed on a > monthly basis. The problem is that SQL server 7 can't execute it. It fails > every time. If we run the package manually it works just fine. > > Any ideas? > > Thanks, > > Steven D Dworman > --------------------------------------------------------- > Web Consultant > Systems Administrator > > ComSpec International - http://www.comspec-intnl.com > phone: 248.647.8841 > cell: 734.972.9676 > --------------------------------------------------------- > EMPOWER-XL ***Software for Higher Education*** > http://www.empower-xl.com ______________________________________________________________________ Get the mailserver that powers this list at http://www.coolfusion.com Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
