Skip first row?
Posted: Fri Jun 20, 2014 1:53 pm
I am using the ReadCSV task to process records from a downloaded file.
I use the Data feature in the ReadCSV task to specify and setup each column/index.
The first record on the file is a header record with 4 columns - I need to bypass this record. The remaining records are detail records with 256 columns.
I set the Skip First Row field on the ReadCSV task to TRUE, but either it's not working or I'm using it in an invalid manner.
The project execution blows up with the message Read Data File(s)] Invalid column index '5'. Input file contains only '4' columns. This is telling me that it's trying to process the first record which is the header record.
Am I attempting to use the Skip First Row value in a way other than what is was intended? I have attached the XML view of my project if this helps.
I use the Data feature in the ReadCSV task to specify and setup each column/index.
The first record on the file is a header record with 4 columns - I need to bypass this record. The remaining records are detail records with 256 columns.
I set the Skip First Row field on the ReadCSV task to TRUE, but either it's not working or I'm using it in an invalid manner.
The project execution blows up with the message Read Data File(s)] Invalid column index '5'. Input file contains only '4' columns. This is telling me that it's trying to process the first record which is the header record.
Am I attempting to use the Skip First Row value in a way other than what is was intended? I have attached the XML view of my project if this helps.