In the ActiveX script for the transfromation task of my DTS package, I tried to assign the current datetime to the destination field:
DTSDestination("From_Date") = NOW

When I tested the transformation task, I got the following error:
ActiveX Scripting Transform '<DTS Test Transformation>': 'Function now is not found in the script.

Even if I delete the code "DTSDestination("From_Date") = NOW" from the ActiveX script, I got the same error. It is very strange.

Anyone knows how to solve this problem? Thanks!