Connection manager name problem in SSIS ? Where the connection managers are stored ?

• VG-619426

  Hall of Fame

  Points: 3914

  More actions

  October 6, 2008 at 11:38 am

  #193972

  Hi,

  Is it only me facing this weird problem ?

  When we define connection manager, say OLEDb connection manager, it creates with servername.databasename, which I din;t like and I am having problem with. When we rename it. it was renamed only in the current package, not in the connection manager list. If I want to select for different SSIS package the same connection manager name, I need to this all again. It is not picking this info from configuration files. I am sure I have changed XML configuration files and stored on a common folder.

  Everything was fine until I am having SSIS package deployment in SSIS with configuration files.

  My connection manager name : servername.databasename, which is stored in XML configuration file. When I try to deploy it to different server, it only changes the value of the connection manager not the name, like servername.databasename = server2, which throws error in the server 2.

  I changed means, renamed connection manager file name in one SSIS package, then I deleted my configuration and added new configuration files which has this connection manager name and redeployed to server. So, I was thinking if your configuration files changes, it should reflect in all SSIS packages right ? I shouldn't be doing deleting connection managers and configuration and adding them again right ?

  Where the connection managers are stored on a server, so that I can edit one universal place ?

  PLease share your thoughts.

  Thank you,

  VG