Microsoft KB Archive/246326

From BetaArchive Wiki
Knowledge Base

BUG: Bulk Insert Task in a DTS Package Fails on an SQL Active/Passive Cluster Setup

Article ID: 246326

Article Last Modified on 10/16/2002


  • Microsoft SQL Server 7.0 Standard Edition

This article was previously published under Q246326

BUG #: 56270 (SQLBUG_70)


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'.


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.


Use these steps to work around this behavior:

  1. Copy the impprov.dll file to the \Mssql7\Binn directory on the local drive of the secondary node where the client utilities are installed.
  2. Register the COM DLL on the secondary node using the following:

    regsvr32 impprov.dll


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