Can't create BULKIMPORTSTREAM - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2000 Forums

Import/Export (DTS) and Replication (2000)

Can't create BULKIMPORTSTREAM

Author

Topic

izaltsman
A custom title

1139 Posts

Posted - 2002-12-06 : 10:20:42

Hi All!

I have an instance of MSDE installed on a machine.
When I run a script that is supposed to perform a bunch of BULK INSERT commands, it bombs with the following message:

Msg 7302, Level 16, State 1, Server MSDE_TEST, Line 1
Could not create an instance of OLE DB provider 'BULKIMPORTSTREAM'.

Any thoughts as to why I might be getting this?
All suggestions are greatly appreciated.

PS
Re-installing MDAC doesn't help.

Page47
Master Smack Fu Yak Hacker

2878 Posts

Posted - 2002-12-06 : 10:27:34

I've had problems using Bulk Insert in batches that also us sp_OA* ...

Have a read through http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=14926 and follow the links for 'here' and 'this'.

Jay White
{0}

izaltsman
A custom title

1139 Posts

Posted - 2002-12-06 : 11:05:10

Thanks. But it doesn't look like I'm experiencing the same problem described there, as I'm not using any sp_OA* procs.
In fact, I just tried running a BULK INSERT statement all by itelf (rather than as a part of a larger script), and it still bombed with error 7302.

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources