Updating ServerName in ADO.NET connection

• Filipe

  SSC-Addicted

  Points: 499

  More actions

  May 5, 2016 at 9:16 am

  #318707

  I inherited a SSIS package using SQL 2008 R2, that has several ADO.NET connections defined.

  The original developer has the connections pointing to his local environment and of course I do not have access to it.

  My problem is that when I try and replace the value in ServerName with a server I have access to, or when I try and change the connection string to point to a different server, I am able to do that, but the changes "don't stick". When I get out of the connection and come back in the original values are still there.

  I can override the connection string at run time with no problem, but at design time I cannot do it.

  Any ideas?

• frederico_fonseca

  SSCoach

  Points: 16208

  More actions

  May 5, 2016 at 9:57 am

  #1876902

  the original developer has most likely defined a expression to build the connection string - on the properties of the connection, look for expressions and see what is there.

  Most common is to set the connection string to a variable. this variable is easily updated from a config file or even command line /SET (or /PAR) when executing the package.

• Filipe

  SSC-Addicted

  Points: 499

  More actions

  May 5, 2016 at 10:06 am

  #1876904

  Close enough. He had defined a variable for ServerName and that was overriding my changes.

  Thanks for the help.