How to mimic SSIS with production connection string on development machine -

How to mimic SSIS with production connection string on development machine -

scenario :

ssis in production uses production connection , instance name of sql server.

once open same ssis on machine, connection break since not have access prod.

i can alter connection , utilize local dev, mean whenever deploy production have inquire network guys open ssis , alter connections local production, each sql task.

is there way me mimic production connection on dev not have touch connection strings prod , able debugging / modifications , upload production?

you need create utilize of ssis package configurations allow store configurable values in 1 of next options:

xml configuration file environment variable registry entry parent bundle variable sql server table

read more bundle configuration on msdn, below documentation link refers ssis 2012.

package configurations

i prefer sql server table because gives flexibility update values using t-sql queries. when develop package, select connection managers , variables think might require different values across environments. 1 time create bundle configuration, can move bundle , modify values on bundle configuration xml file or sql server table without having touch bundle (.dtsx)

refer reply below question detailed steps on how create utilize of bundle configurations:

run ssis bundle 2 different configurations

ssis database-connection