Home

BCP command with a format file to skip a header row issue.

Highlighted
Salman70
Occasional Visitor

While using BCP command with format file to insert a large file i.e. 7GB in size export to database table without a header row then we unable to insert the first row of data.

I used -F1 and -F2 both in PowerShell command for skipping the header only but both are not working.

The main problem is my header contains only 3 columns and the data is about 13 columns that's why the first record is included with a header.

My sample data is as follows : 

 

HEADER|TAXLOT|20180104
A35972|01859M408|20170109|57.8270|504.84|0|0.00|0.00||0|0|CLSIT1|
A35972|63872T729|20161027|211.3820|2088.46|0|0.00|0.00||0|0|ASXTU5|
A35972|63872T729|20161123|195.3990|1911.00|0|0.00|0.00||0|0|ASXTU5|
A35972|63872T729|20170404|3.8540|38.00|0|0.00|0.00||0|0|ASXTU5|

TRAILER|TAXLOT|20180104|18954837

 

In this sample data, the record that is in bold is not inserted in the database.

 

Can anyone please suggest any solution?