how to use configs to switch between SQL and integrated security

[dwaine]

it seems that when a configuration is defined at design time as integrated
security there is no simple way to change that setting using configs at run
time.

You can add username and password values, but when the connection string is
rebuilt, the "Integrated Security=SSPI;" parm is left over and the userid/pwd
are ignored.

there is no apparent way to remove the "Integrated Security=SSPI;" clause
using configured properties.

Does one have to resort to configuring the entire connection string? Then
this is rebuilt and lost if any other property of the connection is defined
elsewhere.

Please advise.

[Charles Wang [MSFT]]

Hi Dwain,
Welcome to Microsoft MSDN Managed Newsgroup.

If you want to override the connection settings in your package at design
time, you can use the option /Connection. Please refer to this article:
dtexec Utility
http://msdn.microsoft.com/en-us/library/ms162810.aspx

Hope this helps.

Best regards,
Charles Wang
Microsoft Online Community Support
===========================================================
Delighting our customers is our #1 priority. We welcome your
comments and suggestions about how we can improve the
support we provide to you. Please feel free to let my manager
know what you think of the level of service provided. You can
send feedback directly to my manager at: ***@microsoft.com.
===========================================================
Get notification to my posts through email? Please refer to
http://msdn.microsoft.com/subscriptions/managednewsgroups/default.aspx#notif
ications.

Note: MSDN Managed Newsgroup support offering is for non-urgent issues
where an initial response from the community or a Microsoft Support
Engineer within 2 business day is acceptable. Please note that each follow
up response may take approximately 2 business days as the support
professional working with you may need further investigation to reach the
most efficient resolution. The offering is not appropriate for situations
that require urgent, real-time or phone-based interactions. Issues of this
nature are best handled working with a dedicated Microsoft Support Engineer
by contacting Microsoft Customer Support Services (CSS) at
http://msdn.microsoft.com/en-us/subscriptions/aa948874.aspx.
============================================================
This posting is provided "AS IS" with no warranties, and confers no rights.
=========================================================