Unanswered: Microsoft OLE DB Provider for SQL Error
I have created a new dts job from my client SQL Server but I am not able to run it from here. If I run it on the server it runs fine but when I try to run it from my client I am getting an error
"Error Source: Microsoft OLE DB Provider for SQL Server
Error description:[DBNETLIB] [Connection open (Connect())] SQL Server does not exist or Access denied"
Query analyser is working fine with all my databases but not my jobs.