I have one important question, I am new in SSIS. I have develop SSIS Package in our DEV Environment. Database Point to Dev Server and all Source files are in point to Dev Environments. My question is, now I want to move this package to QA Environment and then one QA done I would like to transfer in Production Environment.
My question is what is the best way to Transfer SSIS Package from Dev to QA and QA to Prod. With changes everytime connection manager and source path and those type of thing.
I would like to know the process in SQL SERVER 2008R2 and soon we will be using SQL Server 2014.