I think I got it I the wording is weird in BULK INSERT so I think the
parameter FIRSTROW will work to remove the header....



Jeff


-----Original Message-----
From: Sheldon Jeff
[mailto:mssqldba-ezmlmshield-x16996725.[Email address protected]
Sent: Tuesday, February 27, 2007 12:42 PM
To: LazyDBA Discussion
Subject: BULK INSERT removing header?

Testing out the stored procedure now and I get my tab delimited file
imported to the table however it produces an error because it tried to
import the file header.



According to BOL the FIRSTROW parameters is not intended to ignore the
header.



Question is it best to strip the header outside of SQL (a la .cmd
action) or is it possible to remove the first row of the file before
importing via SQL?



Jeff





---------------------------------------------------------------------
TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
To post a dba job: http://jobs.lazydba.com
To subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html


MS Sql Server LazyDBA home page