Article ID: 246326
Article Last Modified on 10/16/2002
APPLIES TO
- Microsoft SQL Server 7.0 Standard Edition
This article was previously published under Q246326
BUG #: 56270 (SQLBUG_70)
SYMPTOMS
When SQL Server 7.0 is installed in a clustered environment as an active/passive set up, Data Transformation Services (DTS) packages that contain a bulk insert task fail to execute on the secondary node of the cluster after failover.
The DTS package execution on the command line with DTSRUN utility causes the following message to occur:
CAUSE
When SQL Server is installed in a clustered environment the impprov.dll file is not installed on the secondary node of the cluster. This DLL must be installed and registered on each node of the cluster for the bulk insert DTS task to execute successfully.
WORKAROUND
Use these steps to work around this behavior:
- Copy the impprov.dll file to the \Mssql7\Binn directory on the local drive of the secondary node where the client utilities are installed.
Register the COM DLL on the secondary node using the following:
regsvr32 impprov.dll
STATUS
Microsoft has confirmed this to be a problem in SQL Server 7.0.
Additional query words: dts failure task not connecting to virtual server backup node
Keywords: kbbug kbpending KB246326