The (MSSQL) BCP CLI has an option to skip header rows: "-F". This option is needed specifically for reading files in. There are two interpretations of the number that would be passed in. It is either the number of rows to skip, which would default to 0. Or it is the line on which to start reading, which would default to 1. The latter is the way BCP's -F flag works, but may not be as intuitive in the python mindset. I'm open to arguments, and I'm currently thinking of how the skiprows option works in pandas.read_csv(). I think I want to be consistent with python more than MSSQL BCP.
The (MSSQL) BCP CLI has an option to skip header rows: "-F". This option is needed specifically for reading files in. There are two interpretations of the number that would be passed in. It is either the number of rows to skip, which would default to 0. Or it is the line on which to start reading, which would default to 1. The latter is the way BCP's -F flag works, but may not be as intuitive in the python mindset. I'm open to arguments, and I'm currently thinking of how the skiprows option works in pandas.read_csv(). I think I want to be consistent with python more than MSSQL BCP.