[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