August 18, 2008 at 3:33 pm
Hello everyone, my problem is the follow, I need migrate a package between the Development server to the production server, when I already have the package in the destination server, I need change the data source in Connection String of connection Manager towar the correct server, I select the checkbox and change the connection string, close the package, but when to come back to see the configuration and view connection string, the configuration of data source didn't change, someone tell me how can I fix this please? :crazy:
Angel Miranda Nieto
DBA Specialist, BI, MCSA SQL Server
August 18, 2008 at 3:36 pm
Config files set the variables / properties at runtime. When you open the package with the config file valid, it will alters update the properties. It does not harden the values. You have to carry the config file around with the package. Is this not happening for you?
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!
August 19, 2008 at 5:05 am
1) Export the package to a file
2) Open the file with BIDS
3) Change the connection string
4) Import the package back onto the server
You cannot change the connection string in the package while it is stored on the server, you have to change the default value in BIDS.
As posted previously, I would also recommend using package configurations to allow you to change the connections at runtime.
August 19, 2008 at 5:10 am
It's for that reason that storing packages is MSDB is rubbish.
File based packages are much nicer. Simpler to manager, (don't claim backup reasons), execute etc etc. When editing them, equally as easy.
No import export what version do I have now stuff.
Anyway...
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!
August 20, 2008 at 4:06 pm
thanks to all, is really easy using BIDS, greetings 🙂
Angel Miranda Nieto
DBA Specialist, BI, MCSA SQL Server
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply