Post reply

dts Job Error

  • April 3, 2009 at 11:31 am

    #129592

    Hi

    I have scheduled a dts package. I am getting below error when the job executed

    Error:

    Executed as user: CMC\00SqlService. 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.

    The dts package is working fine if run the steps one by one. Can someone help on this?

    Thanks

    Shuaib

  • April 13, 2009 at 1:19 am

    #976408

    It means that you are not getting an SQL Server connection. If you are using a linked server into an stored procedure then you have to add that server in linked server under security or else connection to that sql server is access denied. Check you connection..i mean uid and pwd aor correct and then try again...

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply