I've a flat file connection manager whose connection string is an expression.
I've set the delay validation property of the flat file connection manager to true.
But it's not allowing me to close flat file connection manager until I define columns in the advanced tab, but the columns have to be generated dynamically based on the expression.
the main reason for this is that I've different types of flat file sources with different columns in them, I can create each connection manager for each type of flat file (by typing each column name in advanced tab of the connection managers) which resolves the above problem.
But is there any way to use a single flat file connection manger for different flat files with different columns?