Loner (9/12/2013)
I am using SQL Server 2008 SSIS.I used to have a DTS package using Dynamic property task so when I move from development to QA and to production, I don't need to open the package to change the database connection to different server and database.
But now I am using SSIS, everytime I change the SSIS package and when I move it to QA and production, I have to open it to change the database connection,
Is there a way to change the database connection without opening the package?
Thanks
This article will be really helpful.
Understanding Integration Services Package Configurations
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP