How to change the the ODBC constring dynamically on run time in ssis

• vipin_jha123

  Hall of Fame

  Points: 3085

  More actions

  August 12, 2015 at 6:39 am

  #306802

  Hi,

  I have one package where source is oracle. Same package will run for different database.

  I am using Microsoft ODBC for Oracle to connect oracle database.

  Is there any way to change the THE ODBC constring dynamically on run time

  Regards,

  Vipin jha

• Phil Parkin

  SSC Guru

  Points: 246979

  More actions

  August 12, 2015 at 9:49 am

  #1819381

  Using not-very-advanced Google search strings suggested yes.

  Try this.

  The absence of evidence is not evidence of absence.
  Martin Rees

  You can lead a horse to water, but a pencil must be lead.
  Stan Laurel