October 13, 2015 at 2:14 am
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
October 13, 2015 at 2:24 am
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.
October 13, 2015 at 3:14 am
No. I just copied the file from my email to my desktop and opened it from there by selecting Open/File....
Is this not the way to do things ?
October 13, 2015 at 3:19 am
No. Create a dummy project, add the package to it, then you should be fine.
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.
October 13, 2015 at 3:32 am
Ok Not sure if i'm doing this right. I created a new Project, then right clicked it, selected 'Add' - 'Existing Package'.
The package opens up with some errors and warnings, but the same problem persists. When I change the server name, I can test the connection ok, but then when I click OK to keep the setting, the package seems to freeze for about 20 secs ( I cant select anything), then when it returns to normal if I go back in and click edit, its got the old server name still..
October 13, 2015 at 3:55 am
Sounds like something is setting this value.
If you click once on the CM and then get properties, can you check the 'Expressions' property – is there anything in there?
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.
October 13, 2015 at 4:03 am
I think I have now fixed this. I right clicked in the control flow, selected 'variables' and changed the values in there. Now the connection manager opens up with the new computer name.
Thanks for your help on this.
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply