How to dynamically select connection properties for oledb sourcece and SQL Destination in SSIS?

• kishore-262367

  SSC Enthusiast

  Points: 111

  More actions

  April 4, 2006 at 1:16 am

  #113657

   

  Here I am mentioning a sample case.Let me know if any one knows solution.

  There will be a table "XYZ" which contain data, DB name and table name.

  How to dynamically select connection properties for oledb sourcece and SQL Destination in SSIS from the table "XYZ" ??

  Source and destinations should be able to select DB name and table name dynamically from the table "XYZ".

  Same work flow should be maintained for all the connections.

   

  With regards

  Kishore

• Jamie Thomson

  SSChampion

  Points: 11805

  More actions

  April 6, 2006 at 10:45 am

  #631307

  Use an Execute SQL task to take those values and store them in variables.

  Then use expressions on the appropriate properties of the connection manager in order to set them to the values stored in those variables.

  -Jamie

   

  Jamie Thomson
  http://sqlblog.com/blogs/jamie_thomson