Converting a DTS package from VB 6.0 to .NET

[Aue]

I post the same question, and I think I am in ther rihgt forum.

I am struggling with a couple of issues relate to the conversion from VB 6 to VB .NET. Specically it is relate Interface 'DTS.OLEDB Properties' cannot be indexes because it has no default property. I know where the problem is but I do not know how to fixed. The problem in the code is every time :

(oConnection.ConnectionProperties) shows up in the code

Here is the code:
Dim oConnection As DTS.Connection2


oConnection = goPackage.Connections.New("Microsoft.Jet.OLEDB.4.0&quot

oConnection.ConnectionProperties("Data Source&quot.Value = “C:\UPLOADS.mdb"

oConnection.ConnectionProperties("Mode&quot.Value = 1
oConnection.Name = "Connection 1"
oConnection.ID = 1
oConnection.Reusable = True
oConnection.ConnectImmediate = False
oConnection.DataSource = “C:\UPLOADS.mdb"
oConnection.ConnectionTimeout = 60
oConnection.UseTrustedConnection = False
oConnection.UseDSL = False
goPackage.Connections.Add(oConnection)


oConnection = goPackage.Connections.New("SQLOLEDB&quot
oConnection.ConnectionProperties("Integrated Security&quot.Value = "SSPI"
oConnection.ConnectionProperties("Persist Security Info&quot.Value = True
oConnection.ConnectionProperties("Initial Catalog&quot.Value = "Test"
oConnection.ConnectionProperties("Data Source&quot.Value = "TestServer"
oConnection.ConnectionProperties("Application Name&quot.Value = "DTS Import/Export Wizard"
oConnection.Name = "Connection 2"
oConnection.ID = 2
oConnection.Reusable = True
oConnection.ConnectImmediate = False
oConnection.DataSource = "TestServer"
oConnection.ConnectionTimeout = 60
oConnection.Catalog = "Test"
oConnection.UseTrustedConnection = True
oConnection.UseDSL = False

goPackage.Connections.Add(oConnection)

thanks

 

[Aue]

I really need a answer, I appreacite your help