Microsoft KB Archive/246326

From BetaArchive Wiki
< Microsoft KB Archive
Revision as of 16:13, 18 July 2020 by 3155ffGd (talk | contribs) (importing KB archive)
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
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



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:

  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
                        


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