Search code examples
ssisconnection-stringflat-file

How to view the ConnectionString value of Flat File Connection while debugging?


There seem to be 2 ways to set up the connection string in FlatFile connection properties:

  1. Using ConnectionString property
  2. Using ConnectionString expression

Which 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)?


Solution

  • As with everything in SSIS, an expression is used to overwrite the value of a property.