Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Administration (2000)
 Job that runs DTS package Error!!

Author  Topic 

elenalg
Starting Member

2 Posts

Posted - 2004-10-20 : 10:47:44
A scheduled job for dts package start sending me an error massage

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. Process Exit Code 1. The step failed.

Manualy running successfully. What can caused the problem?
Any help appreciated.

Elena

CanadaDBA

583 Posts

Posted - 2004-10-20 : 11:05:54
Was it working previously? I mean not running manually.

Canada DBA
Go to Top of Page

elenalg
Starting Member

2 Posts

Posted - 2004-10-20 : 11:20:50
Yes, it was working previously. Just a magic things is goining on.
Go to Top of Page
   

- Advertisement -