How Name Integrated Security

#1

I am setting options dynamically for DTS for a SQL Server connection, and I
am not sure how to set it for SQL Server authentication. What do I use in
place of the last 2 lines?

Set oConnection = oPKG.Connections("Destination")
oConnection.DataSource = DestinationServerName
oConnection.Catalog = DestinationDatabase
oConnection.UserID = UserID
oConnection.Password = myPassword
oConnection.UseTrustedConnection=False 'not sure
oConnection.IntegratedSecurity=False ' not sure

#2

Hello Derek,

Quote:

I am setting options dynamically for DTS for a SQL Server connection,
and I am not sure how to set it for SQL Server authentication. What
do I use in place of the last 2 lines?

Set oConnection = oPKG.Connections("Destination")
oConnection.DataSource = DestinationServerName
oConnection.Catalog = DestinationDatabase
oConnection.UserID = UserID
oConnection.Password = myPassword
oConnection.UseTrustedConnection=False 'not sure
oConnection.IntegratedSecurity=False ' not sure

Set UseTrustedConnection to false, and I would not even set IntegratedSecurity
at all. The are almost duplicates.

#3

What is the DSL setting?

oConnection.UseDSL = False

Derek

"Darren Green" <darren.green (AT) reply-to-newsgroup (DOT) sqldts.com> wrote

Quote:

Hello Derek,

I am setting options dynamically for DTS for a SQL Server connection,
and I am not sure how to set it for SQL Server authentication. What
do I use in place of the last 2 lines?

Set oConnection = oPKG.Connections("Destination")
oConnection.DataSource = DestinationServerName
oConnection.Catalog = DestinationDatabase
oConnection.UserID = UserID
oConnection.Password = myPassword
oConnection.UseTrustedConnection=False 'not sure
oConnection.IntegratedSecurity=False ' not sure

Set UseTrustedConnection to false, and I would not even set
IntegratedSecurity at all. The are almost duplicates.

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

How Name Integrated Security

microsoft.public.sqlserver.dts microsoft.public.sqlserver.dts

How Name Integrated Security - 06-20-2006 , 08:26 PM

Re: How Name Integrated Security - 06-21-2006 , 05:27 PM

Re: How Name Integrated Security - 06-22-2006 , 05:10 PM