Results 1 to 7 of 7

Thread: DTS question

  1. #1
    Join Date
    Mar 2004
    Posts
    18

    Question Unanswered: DTS question

    Say I would use a ActiveX vbScript to query an LDAP server.

    If i then would use that script to run in a DTS package. Witch steps do I have to take? Do i need to make a connection with the database, how do I create links.

    I not looking for an out of the box solution, just maybe some good links to good sites witch explain this problem / question. My search wasn't that successfull

    Greetings,
    Godofredo

  2. #2
    Join Date
    Jul 2003
    Location
    San Antonio, TX
    Posts
    3,662
    Your DTS may contain nothing but an ActiveX script. You create connections inside the script using ADO, RDO, or whatever else you think you can use for it.

  3. #3
    Join Date
    Mar 2004
    Posts
    18
    yes but i want to fill up a table with the information retrieved by the ActiveX script

  4. #4
    Join Date
    Feb 2004
    Location
    San Antonio, TX
    Posts
    565
    you could just create a job that runs your activex script by querying ldap
    and you could make that available to the next available step in the job. you dont really have to run dts. BUt if you want to, SQL Server has access to the ADSI oledb provider . in other words you could link a server to active directory and run a query based on your appropriate LDAP architecture.

  5. #5
    Join Date
    Mar 2004
    Posts
    18

    Thumbs up good good

    This is what a call a straightforward answer

    Thanks,
    Godofredo

  6. #6
    Join Date
    Jul 2003
    Location
    San Antonio, TX
    Posts
    3,662
    Hey, that's because he teaches this stuff...

    Scott does DTS and LDAP...

  7. #7
    Join Date
    Feb 2004
    Location
    San Antonio, TX
    Posts
    565
    "at the same time baby!!!!"


    is this thing on ?? 1.. 2.. 3 ...

Posting Permissions

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