DTSRUN UTILITY - MSSQL 7.0

[spencer8100]

Quick question - are the SQL Server Client Utilities required to execute DTSRUN? Thanks

 

[foxdev]

Good question. When you run a DTS job invoked via Enterprise Manager from your workstation, the DTS job runs in the context of your workstation. For example, if the DTS job references the directory D:\DataIn, when the job runs when invoked from your EM it will look for D:\DataIn on your workstation, not on the server.

So, the question is (I think): if you manually invoke DTSRUN.EXE on the server from your workstation outside of EM (maybe you've got a drive mapped to that directory on the server, so you open a command window, change to that drive, and manually invoke DTSRUN.EXE and pass it the parameters), will it run successfully?

My guess is: no. But I don't have a machine on which to try it. Robert Bradley
Sr. DBA, some big company
cheap prints and oil paintings:

http://www.lowcostprints.com