You must Sign In to post a response.
  • Category: SQL Server

    Error in running DTS Job.

    Hi friends,
    Here am getting error while running DTS job as shown in below.

    Error = -2147467259 (80004005) Error string: Error at Source for Row number 1. Errors encountered so far in this task: 1. Error source: DTS Data Pump Help file: Help context: 0 Error Detail Records: Error: -2147467259 (80004005); Provider Error: 9055 (235F) Error string: [AR System ODBC Driver]Cannot open catalog; Message number = 94. Error source: Microsoft OLE DB Provider for... Process Exit Code 1. The step failed.

    Can anyone provide solutions for this?
    Thanks in advance.
  • #762068

    I cannot propose you a solution for the Error.
    But i think this type of error is happenning as the connection cannot be establised for Task1 of yout DTS package. Please check your datasource connections properly.

    Try to create a package with a file source connection in your local and test if your package is running properly.

    If this simple package also throws this error then there is some problem with VS\SQL Server installation

  • Sign In to post your comments