Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Administration (2000)
 DTS Packages

Author  Topic 

shuvi
Starting Member

4 Posts

Posted - 2005-02-07 : 11:33:09
Does anyone have any information about DTS packages for me? It runs fine manually but when I try to schedule it I get "Process Exit Code 14". Please help!

nr
SQLTeam MVY

12543 Posts

Posted - 2005-02-07 : 12:34:35
When you run it manually do you run it from the server or your client m/c.
DTS is a client application so will run where it is loaded.
It could be that it is expecting a path relative to your m/c rather than the server.

Other main difference is that it will run under the sql server service profile (probably) when scheduled rather than your profile and maybe that desn't have the correct permissions.

==========================================
Cursors are useful if you don't know sql.
DTS can be used in a similar way.
Beer is not cold and it isn't fizzy.
Go to Top of Page
   

- Advertisement -