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 :
In this sample data, the record that is in bold is not inserted in the database.
Can anyone please suggest any solution?