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.

 All Forums
 SQL Server 2005 Forums
 SSIS and Import/Export (2005)
 Package Configuration using tables.

Author  Topic 

carumuga
Posting Yak Master

174 Posts

Posted - 2008-07-17 : 07:14:07
Hi,

I developed the package which i want to move from test to production using Package Configuration with tables. I was succesful to create the table and log the values in the config table. But when i migrated the package to the Production server, my packages doesnt run and its pointing to the old connection. I also copied the data and table manually to the target server but the package doesnt have the connection string of the config table information. Could anyone tried out with Table configuration. How do the package know where to pick the information such databasename, tablename (config table)
Please help me on this.

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2008-07-17 : 11:57:21
http://rafael-salas.blogspot.com/2007/01/ssis-package-configurations-using-sql.html
Go to Top of Page
   

- Advertisement -