Step Error code: 80040E37

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: Zaighum (zyazdan_at_xavor.com)
Date: 12/10/04 

Date: Fri, 10 Dec 2004 16:18:16 +0500

We get the following error while running a bat file that contains DTS
package.

 ERROR:

 Step Error Source: Microsoft OLE DB Provider for ODBC Drivers

Step Error Description:[Microsoft][ODBC SQL Server Driver][SQL Server]The
cursor was not declared. (Microsoft OLE DB Provider for ODBC Drivers
(80040e37): [Microsoft][ODBC SQL Server Driver][SQL Server]Invalid object
name <db.tablename>

Step Error code: 80040E37

Step Error Help File:

Step Error Help Context ID: 0

                        What we can make out of this is that at the start,
when the package runs (to transfer several tables from one database to
another), it doesn't create the table at the destination and tries to copy
the data in a table that has not been created for some unknown reason. Any
suggestion regarding the possible solution to the problem would be welcomed
as the package for some reason doesn't create the table at the destination
and straightaway tries to copy the data into the destination table.

Thanks in advance :)

Zaighum.

Relevant Pages