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 |
|
dhw
Constraint Violating Yak Guru
332 Posts |
 Posted - 2009-02-19 : 18:11:17
|
| Hello -I am trying to figure out how to properly use the Package Configuration using SQL Server table for the configuration.I am able to follow these three sites:[url]http://www.mssqltips.com/tip.asp?tip=1405[/url][url]http://www.dotnetjunkies.com/WebLog/appeng/archive/2006/05/30/indirectconfigpackagessis.aspx[/url][url]http://rafael-salas.blogspot.com/2007/01/ssis-package-configurations-using-sql.html[/url]I have six servers - Dev (my local), Test and Prod - for both data sources (sql server 2005) and data destinations (also sql 2005). So, three servers are data source for Dev, Test and Prod and three servers are for data destination for Dev, Test and Prod.For the data desination servers, for example, each one as the same Database name and table name that I am trying to move data into from the appropriate source server (which also has the same Database name and table on each server for the source).What I am having a difficult time with is...once I have the system environment variable created on each server and then have followed the above sites to create the "indirect" connection for the SSIS Configuration data....then what? ANd I put the SQL Server SSIS config table on each server as well. Perhaps this is so simple that I am overlookig something, but I don't see how or where I would get my ssis package that I run (and also store on each server so I can schedule a job) , to pick up the dynamic configuration elements from the Package Configuration. I am trying to only update the ServerName as my environment variable.I am wondering what I need to do next.Thanks for any help or suggestions. - will |
|
|
|
|
|
Help w/Package Configuration using SQL table