Guest_imported
New member
- Jan 1, 1970
- 0
Hello All,
I want to be able to execute a DTS package from on the database server from a remote server. For example, on the Web server issue the command "dtsrun /SmyServer /NmyPackage" and have the package that is on the Web server execute. I know I can do this if Enterprise Manager is also installed on the Web server, but that makes me nervous from a security standpoint. If I try and do this without Enterprise Manager on the Web server I always receive the following error:
DTSRun: Cannot create COM Server to load and execute DTS Package. Error -21472
21164 (80040154): Class not registered
Any help on how I can execute DTSRun remotely would be greatly appreciated.
David
I want to be able to execute a DTS package from on the database server from a remote server. For example, on the Web server issue the command "dtsrun /SmyServer /NmyPackage" and have the package that is on the Web server execute. I know I can do this if Enterprise Manager is also installed on the Web server, but that makes me nervous from a security standpoint. If I try and do this without Enterprise Manager on the Web server I always receive the following error:
DTSRun: Cannot create COM Server to load and execute DTS Package. Error -21472
21164 (80040154): Class not registered
Any help on how I can execute DTSRun remotely would be greatly appreciated.
David