Avatar of IGerasimov
IGerasimov
Flag for United States of America asked on

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).
Microsoft SQL Server 2008

Avatar of undefined
Last Comment
jawaharroy

8/22/2022 - Mon
ASKER CERTIFIED SOLUTION
jawaharroy

Log in or sign up to see answer
Become an EE member today7-DAY FREE TRIAL
Members can start a 7-Day Free trial then enjoy unlimited access to the platform
Sign up - Free for 7 days
or
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
Not exactly the question you had in mind?
Sign up for an EE membership and get your own personalized solution. With an EE membership, you can ask unlimited troubleshooting, research, or opinion questions.
ask a question
All of life is about relationships, and EE has made a viirtual community a real community. It lifts everyone's boat
William Peck