Pass different values for SQL Server configuration paramenter in two different environments

Question

Using ssis configuration , how package auto detects SQL DB connection in QA and dev env.
when package is called from .bat file

Answer 1

Hi @Sivasankar Rebba ,

May I know if you want to apply SSIS Package Configuration using Environment Variable?

If yes, please refer to the following steps:
1.Create environment variables.
2. Right-click on the control flow region will open the context menu. Please select the Package Configurations.. option from it.
3.Please checkmark the Enable Package Configurations to enable the configurations. Next, click on the Add button * to add a new SSIS Package Configuration using Environment Variable.*

Please refer to SSIS Package Configuration using Environment Variable.

Best regards,
Mona

---

If the answer is helpful, please click "Accept Answer" and upvote it.

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

Answer 2

Hi @Sivasankar Rebba ,

Please provide more details:

• What is your SSIS version?
• Are you using SSIS Catalog?
• Please share *.bat file content

Overall, you need (1) parameterize DB connections via Project parameters, and (2) use SSIS Environments feature and change project parameters per each Environment in SSIS Catalog.