August 3, 2006 at 8:02 am
I'm trying to run a job from sql server 2005, this is the command line
exec
master..xp_cmdshell 'DTSRUN /S "Servername" /U "sa" /P"" /N "mvg_dts_2000.dts" '
I'm getting this error
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
NULL
August 4, 2006 at 10:51 am
I just simulated your example on our servers and noticed a couple of things. First, make sure the "xp_cmdshell" option is enabled on the SQL2005 box. Second, take the ".dts" off the end of the DTS package name.
If it still doesn't work (not to make you feel bad), make sure the server name and sa password are typed correctly (I misspelled our sa password the first time I tried to run the simulation and got denied!).
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply