Post reply

DTS : activeX script problem

  • October 26, 2005 at 3:26 am

    #169562

    Hi all,

    I have a small problem with DTS packages.

    I have several databases, and write DTS package for maintenance purpose. Basically, I have to move old records that are time-stamped from some tables to an archive database.

    I have an ActiveX script to set-up the date where records have to be moved if they are prior to.

    My problem is that the script don't update the GV of my package when I execute the package, but it does when I open the package in design mode and execute the activeX step...

    Does anybody have an idea?

    Thanks

     

  • October 26, 2005 at 3:38 am

    #600064

    Try Setting the Global variable value using Dynamic property.

    This may solve the issue. I am not sure whether you already tried it.

    Johnson

  • October 27, 2005 at 2:48 am

    #600497

    I'm new to DTS, so thanks for the suggestion. I didn't use dynamic property yet but will try.

    BTW, I'd really like to know why it didn't work with my activeX script

  • October 27, 2005 at 6:40 am

    #600542

    after doing some additional test, my script was working fine. the problem is just that the display of the global variables values in the package properties window isn't updated

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply