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

Ashok Hariharan listman at hazard0us.org
Mon Nov 25 02:00:01 CST 2002


>e:\workspace\process_images\images.log

Is this path reachable from SQL Server, if your SQL Server is on a
different server
than the one from which you are running the query, the E:\ must be relative
to the
SQL Server installation.

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

------
Ashok Hariharan
listman(at)hazard0us.org
http://www.unganisha.org
------






More information about the thelist mailing list