BUG: Bulk Insert Task in a DTS Package Fails on an SQL Active/Passive Cluster Setup (246326)
The information in this article applies to:
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:
Error: -2147217900 (80040e14)
Could not create an instance of oledb provider 'stream'.
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.
| Modification Type: | Major | Last Reviewed: | 10/16/2002 |
|---|
| Keywords: | kbBug KB246326 |
|---|
|