Dtsrun "Cannot Create COM Server"

[OASystems]

I have created a batch file that uses dtsrun.exe to execute a dts package on my SQL Server, it works fine when I run it off a machine that has SQL Server.

I want this to be able to be used by a user who is on a windows 98 machine that does not have SQL SErver installed, ie he doesn't need SQL Server access he just needs to kick off the job, as the batch file contains Server and login information.

The following message is returned "Cannot Create COM server to load and execute DTS package". I guess this has to do with him not having SQL Server on his machine, is there anything I can do to enable him to run this short of installing SQL server?

Thanks.

 

[aalmeida]

Try to create a batch file for him that would call your program remotely something just like Autoexec.bat or even better you could send an e_mail to start the batch as well. AL Almeida
NT/DB Admin
"May all those that come behind us, find us faithfull"