July 11, 2002 at 2:44 pm
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,
July 12, 2002 at 5:39 am
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)
August 2, 2002 at 8:44 am
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
August 6, 2002 at 1:23 pm
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?
September 3, 2002 at 7:23 am
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
September 3, 2002 at 8:09 am
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
September 23, 2004 at 3:28 pm
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