[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