BULK INSERT runs successfully but no records in the table

• Sandeep-372863

  Newbie

  Points: 7

  More actions

  January 20, 2009 at 2:17 pm

  #200312

  Our SQL server database was on sql server 2000 service pack 3. I have installed service pack 4. Now when I run bulk insert using text file, it shows me that command ran successfully but records are not inserting into the table. I am not getting any error message. I tried with ERRORFILE parameter but file is not created. Need your help.

  Thanks....

• dbamohsin

  SSCommitted

  Points: 1948

  More actions

  January 23, 2009 at 9:09 am

  #931856

  Can you post the syntax your using? also did the Bulk insert work before you patched to SP4?

  My DBA Ramblings - SQL Server | Oracle | MySQL | MongoDB | Access[/url]