DTSRun runs with error

Question

DTSRun runs with error

hnguyenn

SSC-Addicted

Points: 411
More actions
July 11, 2002 at 2:44 pm

#105089

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,

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

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

Antares686 SSC Guru Points: 125444 More actions · Answer 1

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)

Ranjit Wimalaratne SSC Enthusiast Points: 111 More actions · Answer 2

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

Deuce SSCrazy Points: 2712 More actions · Answer 3

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?

timwilliams Ten Centuries Points: 1007 More actions · Answer 4

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

Ranjit Wimalaratne SSC Enthusiast Points: 111 More actions · Answer 5

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

Pancho Villa SSC Veteran Points: 222 More actions · Answer 6

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