[thelist] SQL2k: BULK INSERT not failing but also not creating row

Joshua Olson joshua at waetech.com
Sat Nov 23 08:59:01 CST 2002


Hi gang,

On SQL Server 2k I'm using BULK INSERT to import a tab delimited text file
into a table.  After I got the row and column delimiters worked out, the
code didn't error in Query Analyzer but for some reason there are still no
rows in the table.  Any thoughts?  The T-SQL code is as follows:

BULK INSERT image_log_staging
FROM 'e:\workspace\process_images\images.log'
WITH
(
  FIRSTROW = 2,
  ROWTERMINATOR = '\r\n'
)

Pretty cut and dry.  No errors.  But no data either.

Thanks in advance.

-joshua




More information about the thelist mailing list