Flat File Connection Manager HeaderRowsToSkip not modifiable at runtime?

I have been working with flat file connection managers for a while now, and I have found it very useful to set properties on all types of SSIS objects using expressions that are set to SSIS package variables.

We have recently moved towards using a centralized application configuration infrastructure, so we are now loading up all application configuration information from our own system -- it's actually based off of the 2.0 ConfigurationManager.

I have developed a custom control flow task that will retrieve all of the SSIS variable information from our own application configuration system and set all of the SSIS variables as the first step in a package.

When I have been using this to set the SSIS Variables which are used in expressions for the HeaderRowsToSkip and DataRowsToSkip (there may be others, but I have not tested them yet) properties of flat file connection managers, these values are not being used -- instead it is using the values for the variables that are defined in the package itself (i.e. the default values that I set up in BIDS when developing the package). The ConnectionString property on the flat file connection manager does not exhibit this behavior.

Can anyone provide any insight on this? Is this a bug in SSIS, or is there something that I am missing here?

Thanks in advance.

Sounds like a great big stonking bug to me. Could you log it at Microsoft Connect?

-Jamie

|||certainly will do -- by the way, love your blog -- it's one of my favorite resources for SSIS development issues.|||

Glad to hear it. I really appreciate the feedback.

-Jamie