• 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