Unanswered: SSIS Connection manager not skipping specified header rows
I am experiencing a problem with a header row in a flat file not being skipped. When I preview it in Visual Studio everythign is fine, but when I run the package, it tries to process the header row, resulting in an error. The configuration of the connection manager is set from an XML configuration file so that the package can be deployed to successive environments (Development, Test, Production) without changes to the package proper.
When I disable using configurations and set all of the parameters in the package, it works. Apparently, it DOES NOT READ THIS PARAMETER FROM THE .DTSConfig FILE.
The entry below shows that the HeaderRowsToSkip is properly set to 1.
I'm at a loss here, and can't find any mention online of anyone else experiencing this problem. Any ideas?
NOTE: I have had the suggestion of turning on the ColumnNamesInFirstDataRow property, but the first row is NOT column headers. It is data about the file: user who generated it, date and time, etc. If I use this, it invalidates tansformations because it doesn't have the same headers the next time a file arrives. This file comes from one of our largest customers and is a general file sent to all of their accounts so we cannot request it be changed.