Experienced a rather odd problem today … I scripted out multiple jobs from a SQL2000 environment using SSMS 2008 that call DTS packages. The command line for the jobs looked like DTSRUN /S “Server\Instance” /N “PackageName” /E. When I ran the jobs, they continually returned:
DTSRun: Loading…
Error: -2147467259 (80004005); Provider Error: 17 (11)
Error string: [DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access denied.
Error source: Microsoft OLE DB Provider for SQL Server
Help file:
Help context: 0
I then took the command to a command prompt locally on the server, and the same error presented itself. Without going into all the other troubleshooting I did to find resolution, the problem ended up being that when using SSMS 2008, somehow there were hidden ascii characters in the command line. I found resolution by simply retyping the command. I then verified that the problem was indeed SSMS 2008 as I used SSMS 2005 to script and recreate the job again, and it worked without problem.
Hope others find this helpful.
Comments