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
MS Sql Server LazyDBA home page