Results 1 to 5 of 5
  1. #1
    Join Date
    May 2003
    Location
    Atlanta, GA
    Posts
    187

    Unanswered: SQL2005 Integration Services and VB6

    Hi all,
    As most of you know SQL2005 does not have DTS packages anymore. I have a VB6 app that use to execute the DTS packages on fly. With SQL2005 Integration Services it does not work the same and I can't find anywhere on how to execute the Integration Services Package.
    Can someone help me with this.
    Execute Integration Services Package with VB6.

    Thanks.

  2. #2
    Join Date
    Jan 2007
    Location
    UK
    Posts
    11,434
    Provided Answers: 10

  3. #3
    Join Date
    May 2003
    Location
    Atlanta, GA
    Posts
    187
    Thanks, this may work.
    Do you know if there is anything I can use like in SQL2000? Where you reference a DTS dll and then use the functions like:

    Dim objPackage As DTS.Package2

    Set objPackage = New DTS.Package2
    objPackage.LoadFromSQLServer "SQL_PROD", _
    "sa", "", DTSSQLStgFlag_UseTrustedConnection, _
    "", "", "", PackageName

    'Run the package and release references.
    objPackage.Execute

  4. #4
    Join Date
    May 2003
    Location
    Atlanta, GA
    Posts
    187
    Also, if I use dtexec Utility, I assume I have to redestribute it to every user of the app, right? Where do I get the distribution copy of the util?

  5. #5
    Join Date
    May 2003
    Location
    Atlanta, GA
    Posts
    187
    Any other suggestions please?

Posting Permissions

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