SSIS - Package Configuration using Tables
I developed the package which i want to move from test to production using Package Configurtion 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 from the target server/db.
Please help me on this.