What is the easiest way to "GLOBAL" replace the connection string in my SSIS Package from "Test" to "PRODUCTION"? To do this manually will take about 2 hours! Thank youspeedworker

The Solution that I found is to change the name of the connection in connection manange to common name regardless of the actual connection. 1. SQLSVR_PROD <-------Change the Name to cnnSQLServer 2. SQLSVR_Test <--------Change the Name to cnnSQLServer This allows you to edit the connection to the server thru connection manager from PROD (Production) to Test (test environment) in one step because the connection name doesn't change (just the string behind the connection. Kody_Devl