Steps for Migration from DTS To SSIS

Hi and thank you all for helping

I have 3 DTS Task within the project.  that I want to convert/rewrite

I have this code from the first Task in a DTS Package:

'**********************************************************************
'  Visual Basic ActiveX Script
'************************************************************************
option explicit

Function Main()
      Dim pkg ' as DTS.Package
      set pkg = DTSGlobalVariables.Parent
      Dim oStep ' as DTS.Step
      For each oStep in pkg.Steps
            oStep.ExecuteInMainThread= true
      next 'oStep
     
      Main = DTSTaskExecResult_Success
End Function

From what I can see is all this does is links connections and I can do the same thing in BIDS(SSIS) by just using:

1.) Execute SQL Task
2.) create a connection Manager - using the provider for the Access 2003

IS THIS CORRECT?
If not please step-by-step process
I don't want to just use:
Execute Package Task is the simplest solution to execute other packages.
Because that is just using another package(DTS) instead of SSIS
I have to rewrite from DTS to SSIS (not use DTS)


Ok, now the second Task:
Using ActiveX Script Task Properties:
This is the code:
option explicit

Function Main()
      Dim oAccess 'As Access.Application
      Set oAccess = CreateObject("Access.Application")
      oAccess.visible=true
      oAccess.OpenCurrentDatabase "d:\Jobs\2007NADA\NADAAssessments_V1.mdb"
      oAccess.Forms("frmRun").cmdRun_click
      oAccess.CloseCurrentDatabase
      oAccess.Quit
      Set oAccess = Nothing
      Main = DTSTaskExecResult_Success
End Function


Now on the SSIS side:
1.) used Script Task
2.) Design Script button
3.) copied the code above

IS THIS CORRECT?
Fig1.docx