I was hoping for an option like: The instance disappears in a puff of smoke!

I ran this on 2008 R2 and it ran without error and returned no rows.

Well done. Very understandable.

Thanks

-Mike Hayes

OK. Here's what I did.

I was getting an error on your XML Configuration file, so I created one with the following:

<?xml version="1.0"?>

<DTSConfiguration>

<DTSConfigurationHeading>

<DTSConfigurationFileInfo

GeneratedBy="BCOHOME\E100557"

GeneratedFromPackageName="Load_mlh_test_job_history"

GeneratedFromPackageID="{2FB9E723-3F10-48EF-9F7F-D378EEC6FBB7}"

GeneratedDate="6/29/2012 3:06:19 PM"

/>

</DTSConfigurationHeading>

<Configuration ConfiguredType="Property" Path="\Package.Connections[CDW_ETL_Config].Properties[ConnectionString]" ValueType="String">

<ConfiguredValue>Data Source=mpcdw02r\instance2;Initial...

Thanks so much for taking all this time to reply to my message. It'll take a while for me to get this setup and tested. I'm not sure...

The production configuration table is hosted on the production server. The development configuration table is hosted on the development server (likewise test on test).

The connections in the...