Friday, February 24, 2012

Could not create an instance of OLE DB provider 'BULKIMPORTSTREAM'?

Just upgraded SQL Server to SP4 (plus hotfixes) this past weekend, and
now BULK INSERT doesn't seem to work.
Microsoft SQL Server 2000 - 8.00.2187 (Intel X86) Mar 9 2006
11:38:51
create table ##Holding_Tank (full_record varchar(500))
BULK INSERT ##Holding_Tank
FROM 'g:\narf.txt'
WITH
(
ROWTERMINATOR = '0x0a',
TABLOCK
)
Could not create an instance of OLE DB provider 'BULKIMPORTSTREAM'.
OLE DB error trace [Non-interface error: CoCreate of DSO for
BULKIMPORTSTREAM returned 0x8007045a].
Any suggestions?
On Mar 2, 11:17 am, bour...@.gmail.com wrote:
> Just upgraded SQL Server to SP4 (plus hotfixes) this past weekend, and
> now BULK INSERT doesn't seem to work.
> Microsoft SQL Server 2000 - 8.00.2187 (Intel X86) Mar 9 2006
> 11:38:51
> create table ##Holding_Tank (full_record varchar(500))
> BULK INSERT ##Holding_Tank
> FROM 'g:\narf.txt'
> WITH
> (
> ROWTERMINATOR = '0x0a',
> TABLOCK
> )
> Could not create an instance of OLE DB provider 'BULKIMPORTSTREAM'.
> OLE DB error trace [Non-interface error: CoCreate of DSO for
> BULKIMPORTSTREAM returned 0x8007045a].
> Any suggestions?
The fix appears to be to re-register the impprov dll, followed by
restarting the service.

No comments:

Post a Comment