There seem to be 2 ways to set up the connection string in FlatFile
connection properties:
ConnectionString
propertyConnectionString
expressionWhich one will be used? Is there any way to see this value during the debug, or to print it out (is adding a new task, 'print in a file', a reasonable workaround)?
As with everything in SSIS, an expression is used to overwrite the value of a property.