SSIS question on DATAFLOW task - can you have the connection to be coming from an expression ?

• mw_sql_developer

  SSCoach

  Points: 19445

  More actions

  January 4, 2016 at 8:15 am

  #306747

  Question is about configuring the CONNECTION property to come from a variable at RUN TIME.

  Hello

  Here is how the story goes..

  In a regular "EXECUTE SQL TASK" I was able to make the connection property to come from an expression. So this means, I am able to deploy this package in any database and set a variable that will have the name of the connection.

  Works fine...

  Hmm.. Problem is I am not able to do that with a "DATA FLOW TASK"

  I am sure there is another way to get around that...:-P

  Anyone ?

• John Mitchell-245523

  SSC Guru

  Points: 148809

  More actions

  January 4, 2016 at 8:28 am

  #1849241

  One way to get round it is to dynamically set the properties of the connection manager, instead of the data source.

  John