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 |
|
inbs
Aged Yak Warrior
860 Posts |
 Posted - 2010-06-22 : 10:24:08
|
| how do i use it in develpoment and production enviorments?i read this post:[url]http://www.mssqltips.com/tip.asp?tip=1405[/url]if i have 3 packages,and each package i have same DataSource (DS1)so in the sql table ,i will see 3 DataSource (ConfigurationFilter)? |
|
|
vijayisonly
Master Smack Fu Yak Hacker
1836 Posts |
Posted - 2010-06-22 : 15:11:56
|
| We use XML files for config files. I create variables for the Data Source (same variable in all packages). then use this single config file to execute all packages. You will need to have diff versions of the config files for DEV,QA, Prod etc.We use dtexec to execute the SSIS packages. |
 |
|
|
inbs
Aged Yak Warrior
860 Posts |
Posted - 2010-06-22 : 15:34:46
|
| finally i understand why he create environment variable |
|
|
|
|
|
|
Package Configurations