How to define/changeconnection string runtime

• niranjan.alkari

  Old Hand

  Points: 301

  More actions

  August 20, 2008 at 12:21 am

  #127110

  I have created package in which connection strings are hard coded as usual. But I need to port this package on client machine which is having different instance name but the same data structure . How can I change connection string without changing package code externally ?

  Note : I don't have BIDS at client site

  Help

• Crispin Proctor

  SSCoach

  Points: 18161

  More actions

  August 20, 2008 at 1:22 am

  #860448

  SSIS Config files. Menu > SSIS > COnfig...

  Cheers,CrispinI can't die, there are too many people who still have to meet me!It's not a bug, SQL just misunderstood me!