CODEWITHSUNDEEP
sql-server-2008ssissql-server-2008-r2bids
user3494471
user3494471

Reputation: 371

ssis dynamic connection string variables

I am having collection SSIS packages created by someone.Example shown below enter image description here

In Each and every package they created Variables.Inside my project folder I can able to find Democonnectionstring

enter image description here

Inside the Democonnectionstring enter image description here

What my question is why they are using Variables and DemoConnectionString and if I want to change my Servername and Password where I should change.Any one explain me in detail.

Upvotes: 1

Views: 1692

Answers (2)

Govind
Govind

Reputation: 979

If you want to run your ssis package in BIDS(i.e in your development) you can change variable values in variable window according to your need then run the package. so now you can change your variables in variable window. But how you will change your variable if you have only executable dtsx package but not actual solution.

Here only configuration files comes into picture, where you can change all the dynamic variables without editing your packages. The demo password and password is something they might have created for test purpose. Try to remove one or other password and run the package, if it is working fine then remove unnecessary variables. If the variables prepend USER string then that is user defined variable. Right click your connection and go to properties window and check expression option to see any user variables assigned.

Upvotes: 1

James Rosser
James Rosser

Reputation: 424

Go to the control flow tab and make sure no shapes are selected. Then in the Menu bar expand "SSIS" and go to "Package Configurations"

There you will find a list of configurations which have been set up for the package. I suspect that you'll find a configuration there which uses an XML file to assign values to variables.

Upvotes: 2

Related Questions