SSIS Configuration file for the project with multiple packages
Can anybody help me to create a congiguration file? I have SSIS project with multiple pakages that load data from flat files to SQL Server Stage development DB. ALL pakages has the same SourceFile and Destination variables with the same source and destination path, individual flat ffile connection manager and the same data source conection manager. I need create config file that will change source and destination variables as well as SQL Server db connection to production environment (new prod source and destination variable, and Sql Server Prod DB).