I have a DTS job with a few ActiveX Scripts that process around 400,000 records. I have no choice but to use a script in for the type of data transformation in this case.
Here is my question:
Because I am looping through 400,000 records, if a user hits the cancel button during execution, he/she has to wait until it finishes processing the current ActiveX script. Does anyone know if I can call the DTS package from inside the ActiveX Script to determine if execution has been cancelled by a user? If at all possible, I would want to terminate the Script in about 10 seconds instead of waiting for 30 minutes for the script to finish processing.
Thanks in advance! God Bless,
Mike
Yes, I believe in Jesus. ;-)
"Neither is there salvation in any other: for there is none other name under heaven given among men, whereby we must be saved." (Acts 4:12, KJV)
Here is my question:
Because I am looping through 400,000 records, if a user hits the cancel button during execution, he/she has to wait until it finishes processing the current ActiveX script. Does anyone know if I can call the DTS package from inside the ActiveX Script to determine if execution has been cancelled by a user? If at all possible, I would want to terminate the Script in about 10 seconds instead of waiting for 30 minutes for the script to finish processing.
Thanks in advance! God Bless,
Mike
Yes, I believe in Jesus. ;-)
"Neither is there salvation in any other: for there is none other name under heaven given among men, whereby we must be saved." (Acts 4:12, KJV)