DTS Connection Properties

microsoft.public.sqlserver.programming

1 Dec 2005 9:47 PM

RSH

I have a VB DTS Script I created that uses SQL Authentication as illustrated
in the code below:

'SQL dts connection
    ConnectionIndex = ConnectionIndex + 1
    Set oConnection = oPackage.Connections.New("SQLOLEDB")
    oConnection.ConnectionProperties.Item("Persist Security Info").value =
True
    oConnection.ConnectionProperties.Item("User ID").value =
strSQLServerLogin
    oConnection.ConnectionProperties.Item("Initial Catalog").value =
"master"
    oConnection.ConnectionProperties.Item("Data Source").value =
strSQLServerHostName
    oConnection.ConnectionProperties.Item("Application Name").value = "DTS
Import/Export Wizard"
    oConnection.Name = "cnSQLection" & ConnectionIndex
    oConnection.ID = ConnectionIndex
    oConnection.Reusable = True
    oConnection.ConnectImmediate = False
    oConnection.DataSource = strSQLServerHostName
    oConnection.UserID = strSQLServerLogin
    oConnection.ConnectionTimeout = 60
    oConnection.Catalog = "master"
    oConnection.UseTrustedConnection = False
    oConnection.UseDSL = False
    oConnection.Password = strSQLServerPassword
    oPackage.Connections.Add oConnection
    Set oConnection = Nothing

My question is what do I have to change in order to use Windows
Authentication???

THANKS!
Ron