Why Experts Exchange?

Experts Exchange always has the answer, or at the least points me in the correct direction! It is like having another employee that is extremely experienced.

Jim Murphy
Programmer at Smart IT Solutions

When asked, what has been your best career decision?

Deciding to stick with EE.

Mohamed Asif
Technical Department Head

Being involved with EE helped me to grow personally and professionally.

Carl Webster
CTP, Sr Infrastructure Consultant
Ask ANY Question

Connect with Certified Experts to gain insight and support on specific technology challenges including:

Troubleshooting
Research
Professional Opinions
Ask a Question
Did You Know?

We've partnered with two important charities to provide clean water and computer science education to those who need it most. READ MORE

troubleshooting Question

SSIS Package Deployment

Avatar of ASPDEV
ASPDEV asked on
Microsoft SQL ServerMicrosoft SQL Server 2005
3 Comments1 Solution269 ViewsLast Modified:
Hello,

I need to Deploy an SSIS package on the server, where my connection string I'm getting from config file created on DEV Unit.

How can I Install my package on server, with the Dynamic Conn string, it can be either Windows Authentication or with UserID&Password.I can change the values in my config file, it doesn't seem to taking from my config file.

I'm totally lost on this, how can I set Dynamic Connection string .I tried using variables and expressions but it works on my DEV unit, when I change my values in config file(Hosted on server new changes never effected).


I really appreciate any help....

Thanks
ASKER CERTIFIED SOLUTION
Avatar of Reza Rad
Reza RadFlag of New Zealand imageConsultant, Trainer

Our community of experts have been thoroughly vetted for their expertise and industry experience.

Commented:
This problem has been solved!
Unlock 1 Answer and 3 Comments.
See Answers