<div>
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.<br />
<br />
I have to change any package properties....
</div>


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

<div>
did you set DelayValidation to TRUE in your connection managers inside ssis package?<br />

</div>


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


<div>
<div class="content wysiwyg-content">
Hello,<br />
<br />
I need to Deploy an SSIS package on the server, where my connection string I'm getting from config file created on DEV Unit.<br />
<br />
How can I Install my package on server, with the Dynamic Conn string, it can be either Windows Authentication or with UserID&amp;Password.I can change the values in my config file, it doesn't seem to taking from my config file.<br />
<br />
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).<br />
<br />
<br />
I really appreciate any help....<br />
<br />
Thanks<br />

</div>
</div>


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


SSIS Package Deployment

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.

Microsoft SQL Server

Microsoft SQL Server 2005 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. It includes support for managing XML data and allows a database server to be exposed over web services using Tabular Data Stream (TDS) packets encapsulated within SOAP (protocol) requests.