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 |
|
PatDeV
Posting Yak Master
197 Posts |
 Posted - 2009-01-16 : 10:00:45
|
| Hi all,how can i do this. I don't want to hard code the package variable values when i want to deploy package from dev to test or prod. Is there a way i can store in table and have it passed in when package execute. I know you can set the configuration file with xml or sql but need steps what to store in table or file.also how to execute config file before ssis package execution takes place!!Thanks |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2009-01-16 : 11:17:37
|
| http://rafael-salas.blogspot.com/2007/01/ssis-package-configurations-using-sql.html |
 |
|
|
|
|
|
Varaiable values from SQL table