Configuration Files, Again

Hi,

I am having a hard time grasping how to use configuration files.

Here's an example:

I created a simple package (one execute sql task) that simply does a "select * from xyz". Table xyz only exists on Server 1.

I then created a configuration file, the only setting being the ole db connection manager which is pointing to Server 1. I then went into the file and added the "password=zzz" since it's a sql server login.

When I run the package it worked.

Next, I went into the configuration file I just created and had it point to another server, Server 2, thinking this would now cause the execute sql task to fail since table xyz does not exist on Server 2.

But it's still running succesfully. What's the deal here? Shouldn't changing the configuration file settings cause the package to now fail?

Thanks