JOB EXECUTING DTS PACKAGE FAILS

I am trying to execute a DTS package through a Sql Server Agent Job.
If i execute the dts package myself, it runs fine.
But if i try schedule it, the job fails everytime. Why?
The error i get is:
Executed as user: [server]\SYSTEM. DTSRun: Loading...
Error: -2147467259 (80004005); Provider Error: 6 (6) Error
string: [DBNETLIB][ConnectionOpen (Connect()).]Specified SQL server not
found. Error source: Microsoft OLE DB Provider for SQL Server
Help file: Help context: 0. Process Exit Code 1. The step failed.
i have also tried to execute this as my user account, and got the same error
with:
Executed as user: [server]\[username]. DTSRun: Loading...
Error: -2147467259 (80004005); Provider Error: 6 (6) Error
string: [DBNETLIB][ConnectionOpen (Connect()).]Specified SQL server not
found. Error source: Microsoft OLE DB Provider for SQL Server
Help file: Help context: 0. Process Exit Code 1. The step failed.
Any help would be appreciatedSee if this helps:
http://www.support.microsoft.com/?id=269074
Andrew J. Kelly SQL MVP
"Grant Merwitz" <grant@.magicalia.com> wrote in message
news:OXhGPfC5EHA.1408@.TK2MSFTNGP10.phx.gbl...
>I am trying to execute a DTS package through a Sql Server Agent Job.
> If i execute the dts package myself, it runs fine.
> But if i try schedule it, the job fails everytime. Why?
> The error i get is:
> Executed as user: [server]\SYSTEM. DTSRun: Loading... Error: -2147467259
> (80004005); Provider Error: 6 (6) Error string:
> [DBNETLIB][ConnectionOpen (Connect()).]Specified SQL server not found.
> Error source: Microsoft OLE DB Provider for SQL Server Help file:
> Help context: 0. Process Exit Code 1. The step failed.
> i have also tried to execute this as my user account, and got the same
> error with:
> Executed as user: [server]\[username]. DTSRun: Loading...
> rror: -2147467259 (80004005); Provider Error: 6 (6) Error string:
> [DBNETLIB][ConnectionOpen (Connect()).]Specified SQL server not found.
> Error source: Microsoft OLE DB Provider for SQL Server Help file:
> Help context: 0. Process Exit Code 1. The step failed.
> Any help would be appreciated
>|||thanks, that article seems to have pointed me in the right direction.
"Andrew J. Kelly" <sqlmvpnooospam@.shadhawk.com> wrote in message
news:O4hsIAE5EHA.1204@.TK2MSFTNGP10.phx.gbl...
> See if this helps:
> http://www.support.microsoft.com/?id=269074
>
> --
> Andrew J. Kelly SQL MVP
>
> "Grant Merwitz" <grant@.magicalia.com> wrote in message
> news:OXhGPfC5EHA.1408@.TK2MSFTNGP10.phx.gbl...
>>I am trying to execute a DTS package through a Sql Server Agent Job.
>> If i execute the dts package myself, it runs fine.
>> But if i try schedule it, the job fails everytime. Why?
>> The error i get is:
>> Executed as user: [server]\SYSTEM. DTSRun: Loading...
>> rror: -2147467259 (80004005); Provider Error: 6 (6) Error string:
>> [DBNETLIB][ConnectionOpen (Connect()).]Specified SQL server not found.
>> Error source: Microsoft OLE DB Provider for SQL Server Help file: Help
>> context: 0. Process Exit Code 1. The step failed.
>> i have also tried to execute this as my user account, and got the same
>> error with:
>> Executed as user: [server]\[username]. DTSRun: Loading...
>> ror: -2147467259 (80004005); Provider Error: 6 (6) Error string:
>> [DBNETLIB][ConnectionOpen (Connect()).]Specified SQL server not found.
>> Error source: Microsoft OLE DB Provider for SQL Server Help file: Help
>> context: 0. Process Exit Code 1. The step failed.
>> Any help would be appreciated
>