Is it possible to set up at dataflow with for example an excel source that points to a sheet with varying number of colums.
In the file there is some information about number of columns. But the question is here how you use that information to define the columns in the dataflow ?
The columns in the data-flow need to be known at design-time so by and large you cannot chage things at runtime.
There is a workaround though - you can change a package that you are about to execute using the execute package task. Here's how courtesy of Kirk Haselden: http://www.sqljunkies.com/WebLog/knight_reign/archive/2005/12/31/17731.aspx
-Jamie