Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Curt Blood
Starting Member
23 Posts |
 Posted - 2009-01-16 : 12:19:32
|
| I have six SSIS packages that need to be deployed.4 use database "A"4 use database "B"4 use database "C"For example, package 1 pumps data from "A" to "C"Package 2 pumps data from "C" to "B"Package 3 pumps data from "B" to "A"and so on...Is there a way to deploy them to the file system and point them all to one shared XML configuration file that has the connection strings for the three databases, so the package only takes the connection strings it needs?That way, I can just edit one file when I move from development to test to production, instead of editing a configuration file for ech package.Thanks,Curt |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2009-01-16 : 12:39:08
|
| then cant you store configuration info in a table and use it by means of global variable? |
 |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2009-01-16 : 12:43:28
|
| like:-http://rafael-salas.blogspot.com/2007/01/ssis-package-configurations-using-sql.html |
|
|
|
Curt Blood
Starting Member
23 Posts |
Posted - 2009-01-16 : 12:47:42
|
| I honestly didn't think of that -- I'll have to run it by the client and see if this is acceptable -- they may not want some rogue DBA messing about with their tables. <sigh>Thanks, and if anyone has ideas about the XML, even to say it's impossible, I'd appreciate it.--Curt |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2009-01-16 : 12:54:15
|
| FYI, what i've provided is working solution that we use. Our configuration values are populated in table and used from it. Also we maintain security by giving access only to db owners and all others have to request code changes through promotion process and only db owners run scripts after proper review. |
|
|
|
Curt Blood
Starting Member
23 Posts |
Posted - 2009-01-16 : 12:56:00
|
| Thank you, sir.If they force me to use XML, I can also create a config file for each connection and reuse them that way.I appreciate your help,Curt |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2009-01-16 : 13:01:38
|
No Problem... I will try out if i can share config values using XML file when i'm back in office and post if i'm successful. |
|
|
|
|
|
|
|
|
Sharing XML Configuration between packages