dat file loading | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

dat file loading

Hi, I have a dat file that has some header information in the first line. The header info says what is the record type, date, record count etc. Then the actual data starts. The column delimiter is none and row delimiter is
. How do I intruct BCP to omit the header info and load only the data. I tried with the option firstrow = 2. But unfortunately, the first record starts after the header information on the first line. Any help is highly appreciated.
Hi, I tried removing the header info and saved it as another dat file.
When I run the bcp command, I get the error SQLState = S1002, NativeError = 0
Error = [Microsoft][ODBC SQL Server Driver]Invalid Descriptor Index I have no idea whats going on. Any help is deeply appreciated.

Kindly do not post multiple (duplicate) threads and follow thishttp://www.sql-server-performance.com/forum/topic.asp?TOPIC_ID=4654 thread for further discussion.
Satya SKJ
This posting is provided “AS IS” with no rights for the sake of knowledge sharing.