Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Wanet Telecoms Ltd on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

BULK INSERT - ole db provider

Status
Not open for further replies.

robF

Programmer
Dec 15, 2000
8
US
I am trying to use the BULK INSERT command and keep getting this error:
Server: Msg 7399, Level 16, State 1, Line 1
OLE DB provider 'STREAM' reported an error. The provider did not give any information about the error.
The statement has been terminated.

The exact command i am using is:

BULK INSERT TestDB..Contacts FROM 'C:\ContactsImport.txt'
WITH (FORMATFILE = 'C:\bcp.fmt')

But i can use the bcp command form dos just fine using the same files. Any Ideas?
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top