bulk insert problem

• axa

  Grasshopper

  Points: 18

  More actions

  November 24, 2002 at 1:22 am

  #81253

  I'm trying to insert 100 records from a text (tab delimited) file using bulk insert command.

  Query analyzer returns an error:

  "OleDB provider 'STREAM' reported an error. The provider didn't give any information about the error"

  I'm usung:

  BULK INSERT employees FROM 'C:\data\emps.txt' WITH (KEEPIDENTITY)

  MS SQL server 7,

  WIN2000

  Any ideas?

  Thanks

• Antares686

  SSC Guru

  Points: 125444

  More actions

  November 25, 2002 at 5:45 am

  #442249

  Verify you file does not have any unexpected garbage, bad delimiter in a spot or unexpected end of file by a gap in the data.

  Run several times, sometimes the messages are missed and will appear only sometimes.

  Edited by - antares686 on 11/25/2002 05:46:19 AM