Hi friends,

I've had a DOS batch file (.BAT) that called DTSRUN with some parameters from a second server not the main server itself like this:

DTSRUN /S MainServer /U MyUser /P MyPwd /N MyDtsPackage

It worked because SQL Server was also installed in the second server. But now I want to change all my batchs (.BAT) to another PC which doesn't have SQL Server installed, so when I run the above line DOS gives me the following error:

'DTSRUN' is not recognized as an internal or external command, operable program or batch file.

Then I tried to call DTSRUN from its location on the main server like this:

"\\MainServer\C$\PROGRAM FILES\MICROSOFT SQL SERVER\80\TOOLS\BINN\DTSRUN"

And it gives me the following error:

DTSRun:  Cannot create COM Server to load and execute DTS Package.  Error -2147221164 (80040154):  Class not registered

From what I see I'd need to install some COM Server that DTSRUN calls, or something like that. Is there another way to run a DTS package from a PC which doesn't have SQL Server installed? Any help would be very appreciated.

TIA

Luis