Results 1 to 4 of 4

Thread: Active X script

  1. #1
    Join Date
    Jun 2007

    Unanswered: Active X script

    well i need to write active X script in DTS to go against oracle DB
    and check one of the date field in a table. and if the date field is not older than 1 month then got to next step of dts if not throw warning saying date is not new.

    Not sure how to write in ActiveXscript, i am not a VBScript writer.

    some help please

  2. #2
    Join Date
    Nov 2004
    on the wrong server
    Provided Answers: 6
    this message board thing works better if you try something and post it here. then we cut and paste and fix it for you. Sometimes.
    “If one brings so much courage to this world the world has to kill them or break them, so of course it kills them. The world breaks every one and afterward many are strong at the broken places. But those that will not break it kills. It kills the very good and the very gentle and the very brave impartially. If you are none of these you can be sure it will kill you too but there will be no special hurry.” Earnest Hemingway, A Farewell To Arms.

  3. #3
    Join Date
    Jul 2003
    San Antonio, TX
    You shouldn't have to write an ActiveX script just to check a date in an OLEDB datasource. And Oracle is not an exception.
    "The data in a record depends on the Key to the record, the Whole Key, and
    nothing but the Key, so help me Codd."

  4. #4
    Join Date
    Jun 2007

    Steps in dts

    well, i just wanted to check against a interger field in oracle and if the field is greater than my comparing value then i want it to execute next step in dts, if it is not then i want to execute different step in dts.

    i was thinking about Active x script, i guess there should be easier way to do this.

    Any help is appreciated.

Posting Permissions

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