DTS Problem

[Guest_imported]

Hi,
I have a problem with the DTS setion. I create a DTS on the SQL Server (Which resides on my machine) and no one else is able to access it. It gives an error of File not found. Even I can not access the DTS through an ASP page.
If I go to another machine and create a DTS, it can then be read and executed by anyone, including myself. I can access the other machine-DTS in an ASP Page.
Can anyone help???
Thanks

 

[RickCole]

I think your problem could be that the machines in question have different versions of the SQL server service pack installed. Install the latest services packs on all machines.

If you do have the latest services packs installed then re-install them and try again.

Rick.

 

[Guest_imported]

I have narrowed the problem down to ... if the (local) choice under the Microsoft OLE DB Provider for SQL Server drop down is choosen ... then It will not run. If I force the Server Name in the drop down .. then it runs.