How to make OLE DB connection manager in SSIS dynamic

• ritesh_shri9

  Old Hand

  Points: 332

  More actions

  July 7, 2008 at 4:14 am

  #381515

  Kindly help me out in solving this problem...

  Please tell me how to make the OLE DB connection manager in SSIS dynamic

  I m having 5 locations and i dont want to make different packages to run them so i want to make the connection manager dynamic.

  Please tell me how can i do so?

• Michael Earl-395764

  SSC Guru

  Points: 53873

  More actions

  July 7, 2008 at 6:44 am

  #838807

  There are several ways, but I would suggest you look into package configurations first.

  They are well-documented in books online and there are plenty of articles available by searching google.