Results 1 to 2 of 2

Thread: Create a DTS from VB

  1. #1
    Steve2276
    Guest

    Create a DTS from VB

    I've posted this new thread to see if anyone knows how to dynamically create a SQL Server 7 DTS package using VB.
    RSINGH has assisted me thus far, and I know how to execute a DTS from the VB, but now I want to create one as well.
    I'm told it can be done using SQL DMO.
    Anyone got any tips/ideas for doing this?


  2. #2
    Fanatic Member RSINGH's Avatar
    Join Date
    May 2001
    Location
    London
    Posts
    522
    I have another idea for you. In Enterprise manager you can save a DTS package as a visual basic file. If you do this, it will create a .bas file which will demonstrate the structure of how to create one yourself and provide you with a template which you can then modify to suit your own needs.

    Now the only problem is that there is a lot of code! I did this for a basic file transfer and import package and it is huge.
    The liver is bad. It must be punished.

Posting Permissions

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



Click Here to Expand Forum to Full Width