Hi,

Is there a good or flexiable way to manage connection settings while moving
packages between dev, QA, and production servers?

Thanks

There are a number of ways

1. Pass the new vlue in as a global vriable and use a script task inside the pckage to do the assignment.
2. Use a dynmaic properties task

--

Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.SQLDTS.com - The site for all your DTS needs.
www.SQLIS.com - SQL Server 2005 Integration Services.
www.Konesans.com


"Dave" <Dave (AT) discussions (DOT) microsoft.com> wrote