I am learning SSIS day by day and the question might be simple to most of you all but i am stuck on this. I have to give more background details, We used to have only PROD database earlier and now we started having DEV database with in the same server where my PROD database is. All my SSIS packages are configured to PROD database. I created a variable for connection manager and for the database connection manager i have given expression to pull the variable i defined.
How do i configure when running in my local change the DB connection to DEV and when running of Active Batch server change the connection to PROD db.
Table names, structure are going to be same in DEV and PROD database.
NOTE:I run Active Batch to run my SSIS package and i have env-sys table, when running on Active batch DB connection manager expression will check for environemt_values
Thank you, S