DevX Home    Today's Headlines   Articles Archive   Tip Bank   Forums   

Results 1 to 2 of 2

Thread: Creating SQLServer 7.0 DTS Objects in Visual Basic

  1. #1
    Jimmy Zee Guest

    Creating SQLServer 7.0 DTS Objects in Visual Basic


    Hi,

    I'm creating a DTS package in VB and I need some help.

    The problem is that I need to know the programmatic ID for a text file driver.
    The programmatic ID for SQLServer is SQLOLEDB.1

    example:

    Dim oPackage as New DTS.Package
    dim oConnection as DTS.Connection

    Set oConnection = oPackage.Connections.New("SQLOLEDB.1")

    'The code above is to create a connection to SQLServer
    'what about to a text file????

    Set oConnection = oPackage.Connections.New("??????")

    Thanks in advance,
    Jimmy




  2. #2
    Euan Garden Guest

    Re: Creating SQLServer 7.0 DTS Objects in Visual Basic

    Easiest way to do this is to create the package you want in the DTS
    designer, then:

    1/ In SQL2000 do SaveToVB to see all the code.
    2/ In SQL 7 use the Script Package Utility in dtsdemo.exe on the cd.

    -Euan

    "Jimmy Zee" <jimmy@jim.gq.nu> wrote in message
    news:3ab76789$1@news.devx.com...
    >
    > Hi,
    >
    > I'm creating a DTS package in VB and I need some help.
    >
    > The problem is that I need to know the programmatic ID for a text file

    driver.
    > The programmatic ID for SQLServer is SQLOLEDB.1
    >
    > example:
    >
    > Dim oPackage as New DTS.Package
    > dim oConnection as DTS.Connection
    >
    > Set oConnection = oPackage.Connections.New("SQLOLEDB.1")
    >
    > 'The code above is to create a connection to SQLServer
    > 'what about to a text file????
    >
    > Set oConnection = oPackage.Connections.New("??????")
    >
    > Thanks in advance,
    > Jimmy
    >
    >
    >




Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
HTML5 Development Center
 
 
FAQ
Latest Articles
Java
.NET
XML
Database
Enterprise
Questions? Contact us.
C++
Web Development
Wireless
Latest Tips
Open Source


   Development Centers

   -- Android Development Center
   -- Cloud Development Project Center
   -- HTML5 Development Center
   -- Windows Mobile Development Center