SSIS Package Deployment

ASPDEV used Ask the Experts™

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....

Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®


I tried deploying on the server, and gave Configuration file in package utility section.But the changes I do for the Config File does not reflect.

I have to change any package properties....
Reza RadConsultant, Trainer

did you set DelayValidation to TRUE in your connection managers inside ssis package?

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial