Home Forums Data Warehousing Integration Services can not edit connection manager server name to a new value. RE: can not edit connection manager server name to a new value.

  • October 13, 2015 at 2:24 am

    #1832914

    PearlJammer1 (10/13/2015)

    I am having trouble changing the properties on a connection manager, specifically the server name. I have exported one of our production packages to my work desktop pc. I have then emailed the package to my personal laptop running windows 10 os and sql2014.

    When I open the package using Micorsoft Visual Studio 2012 Shell (integrated) it obviously fails with errors but it does open and I can see the control flow/data flow elements of the package. When I edit the connection managers (right click - edit from the connection manager panel displayed underneath the control flow window) and replace the server name with the name of my new connection, click 'test connection' which passes, then click ok, the connection manager does not remember the new setting. I've tried changing this also in the properties window box underneath the solution explorer but it keep reverting back.

    Do I need to edit something else in order for the connection managers to hold the new info ?

    Thanks

    Did you create a new IS project in VS and add the package to that before attempting to edit it?

    If you haven't even tried to resolve your issue, please don't expect the hard-working volunteers here to waste their time providing links to answers which you could easily have found yourself.