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.
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With