DTSRun runs with error

  • Hi,

    I am having problem to run my DTS package that I saved on my SQL Server 7.0 machine. I get this error

    "Error: -2147217887 (80040E21); Provider Error: 0(0)

    ...Error source: Microsoft OLE DB Provider for SQL Server..."

    Could anyone help me on this. Thank a lot in advance.

    Han,

  • Sounds like you could not connect to the server in your DTS package. How is the connection defined? It is not uncommon for some developers to forget that the name they setup in client network utility does not match anything on the server the DTS package is run from and the package fails with the message. There should be more details depending on how you run it.

    "Don't roll your eyes at me. I will tape them in place." (Teacher on Boston Public)

  • I have a similar problem. It does not happen

    always but at random. This is a normal BCP In

    from one server to another job. The source server is outside the network. It seems the query times out on the source server. But I have set it to zero, meaning unlimited, on that server. So I do not understand what the problem is! Any help please?

    The error messge I get is as follows:

    DTSRun: Loading...

    DTSRun: Executing...

    DTSRun OnStart: DTSStep_DTSExecuteSQLTask_1

    DTSRun OnFinish: DTSStep_DTSExecuteSQLTask_1

    DTSRun OnStart: DTSStep_DTSDataPumpTask_1 DTSRun OnError: DTSStep_DTSDataPumpTask_1, Error = -2147008507 (80074005)

    Error string: Unspecified error Error source: Microsoft Data Transformation Services (DTS) Package

    Help file: sqldts.hlp

    Help context: 1100

    Error Detail Records:

    Error: -2147008507 (80074005);

    Provider Error: 0 (0)

    Error string: Unspecified error Error source: Microsoft Data Transformation Services (DTS) Package

    Help file: sqldts.hlp

    Help context: 1100

    Error: -2147467259 (80004005);

    Provider Error: 0 (0)

    Error string: Timeout expired

    Error source: Microsoft OLE DB Provider for SQL Server

    Help file:

    Help context: 0

    DTSRun OnFinish: DTSStep_DTSDataPumpTask_1

    DTSRun: Package execution complete. Process Exit Code 1.

    The step failed.

    Thanks

    Ranjit

  • Error: -2147467259 (80004005);

    This one drove me crazy for a while. I had a VB program that called a dts package to import an Excel spreadsheet. The error description is; "Selected collating sequence not supported by the operating system".

    Then I found a KB article:

    http://support.microsoft.com/default.aspx?scid=KB;EN-US;Q246167&

    This article basically says; if at first you fail, please try again. That's what I did. After I call package.execute, I check the results of each step (there was only one). If the step failed, I tried executing it again. It would fail the first time, then execute ok the second time. Very weird, but that's M$ for you.

    There are two timeout values in a connection string; command and connection. Are they both set to zero?

  • Hi,

    We have a package that runs every day - 99% of the time it runs with no error - then out of the blue we get the following error;

    DTSRun:

    Loading...

    DTSRun:

    Executing...

    Error: -2147220499 (800403ED);

    Provider Error: 0 (0)

    Error string: No Steps have been defined for the transformation Package.

    Error source: Microsoft Data Transformation Services (DTS) Package

    Help file: sqldts.hlp

    Help context: 700. Process Exit Code 1. The step failed.

    This has happened randomly about 5 or 6 times in the last year - I can find no cause for this - any thoughts?

    Tim

  • quote:


    Error: -2147467259 (80004005);

    This one drove me crazy for a while. I had a VB program that called a dts package to import an Excel spreadsheet. The error description is; "Selected collating sequence not supported by the operating system".

    Then I found a KB article:

    http://support.microsoft.com/default.aspx?scid=KB;EN-US;Q246167&

    This article basically says; if at first you fail, please try again. That's what I did. After I call package.execute, I check the results of each step (there was only one). If the step failed, I tried executing it again. It would fail the first time, then execute ok the second time. Very weird, but that's M$ for you.

    There are two timeout values in a connection string; command and connection. Are they both set to zero?


    Thanks Deuce,

    I will set up the job to check the error code and run it again as suggested.

    >> There are two timeout values in a connection string; command and connection. Are they both set to zero?

    Mine is a data copy from one SQL server to another and does not involve VB. Where do I find these TIMEOUT values?

    Ranjit

  • I only wants to add , that if you make the .exe file of the Visual Basic Program who makes the call to DTS , IT Works only makes an error if you run the code in the VB IDE.

    By the way the Timeout Values are in the connection objects.

    Saludos...

    Pancho

     

Viewing 7 posts - 1 through 6 (of 6 total)

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