DTS : activeX script problem
-
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
-
Try Setting the Global variable value using Dynamic property.
This may solve the issue. I am not sure whether you already tried it.
Johnson
-
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
-
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