Hi,
I am creating a bulk insert package and I generated a format file. I
selected (checked) first row has column names but when I import the data it
import the column names to the table. Why? Pleas assist.

Thanks

Hello Chris,

Are you using DTS or SSIS?
Are you using the BULK INSERT task or are you using the ExecuteSQL Task?

Where is the "First Row Has Column Names" option on either of these tasks?
This is an option when using a Flat File.





Allan Mitchell
www.SQLDTS.com
www.SQLIS.com
www.Konesans.com