I was Using ServerName as an example, remember, Package configs can be used to manipulate any package property.

Lets look @ it this way.

We're dealing with two spheres of SSIS: one being Runtime, the other being Design Time. When you are clicking and dragging and typing and saving in BIDS, that is design time. When you click that green triangle you enter runtime.

In design time, you can see that your database name is set to ABC.

The value for your database name in you config table is set to XYZ.

When you run the package, run time, ie clicking te green triangle, where is the work done? where is the database action taking place? ABC or XYZ.

If your Package configs are configured correctly, it should be XYZ.

When troubleshooting SSIS I ALWAYS reccoment isolating the issue, ie start over with a brand new blank package. In your case you are struggling with Package configs. Personally, I would create a new package, stick a email task in it, with all appropriate requitements (SMTP connection, etc). Send the email to your self, in the subject put "DSTX Value". Run the package, make sure you get the email.

Now add in a package configuation. So create a connection to where your config table is, and go thru the steps of setting up a package config via the Package Config dialog. map the config to the subject line of your email task. Complete the Package Config set up so that your record is saved to your config table.

Go find your new config table record. Notice the Configured Value is 'DSTX Value'. Update this record setting configured Value = 'Config Table Value'.

Go back to BIDS and run your package again. Make sure you get the email, the subject should be "Config Table Value". If its not, scan your output window for warnings and errors.