Forum Posts

Last referers

Visitors Online

Scripting out agent jobs that call DTS packages in SSMS 2008

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 [...]