Results 1 to 2 of 2
  1. #1
    Join Date
    Jan 2004
    Posts
    65

    Unanswered: DTS - How to make ActiveX script open a connection in the diagram?

    I have a simple question but I'm having a really hard time finding an answer.

    Let's say I'm designing a DTS package, and I have a connection to a SQL Server called ConnSQL. How do I reference this connection in my ActiveX script? (so I can run SQL queries and such)

    Thanks
    Last edited by MDesigner; 02-05-04 at 18:53.

  2. #2
    Join Date
    Aug 2003
    Location
    Andover, MA
    Posts
    256
    There is no way to reference such connections. This is because you can only reference COM objects from VBScript, and the DTS package is not a COM object, but itself a script. Scripting is included to allow you to access objects in the operating system environment.

    If you want to run SQL queries against a DTS connection, you want to use a SQL Query task, which operates against whatevery connection you attach it to.

    If your goal is moving data between files and/or tables, you want to use a transformation task between two DTS connections (select the source, holding SHIFT, select the second, then click the Transformation Task button on the toolbar.
    -bpd

Posting Permissions

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