Microsoft KB Archive/246326

= 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

-

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:

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.

Additional query words: dts failure task not connecting to virtual server backup node

Keywords: kbbug kbpending KB246326

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.