Results 1 to 3 of 3
  1. #1
    Join Date
    May 2010
    Posts
    52

    Unanswered: calling a SSIS package in VB

    so we are moving from dts to ssis. my question is. we have an Access app that calls dts package and this is the code:

    Public Function x()

    Dim oPKG As DTS.Package, oStep As DTS.Step
    Set oPKG = New DTS.Package

    Dim sServer As String, sUsername As String, sPassword As String
    Dim sPackageName As String, sMessage As String
    Dim lErr As Long, sSource As String, sDesc As String

    Const DTSSQLStgFlag_UseTrustedConnection = 256

    sServer = "xserver"
    sPackageName = "DTS_Package"
    .
    .
    .
    .
    .
    .
    end function


    we aare still using the same Access app, how do i call a SSIS package like the way the DTS Pacakge is called?

  2. #2
    Join Date
    May 2010
    Posts
    52
    no help!!!!!!!!!

  3. #3
    Join Date
    Aug 2004
    Location
    Dallas, Texas
    Posts
    831
    Try the Visual Basic forum.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •