2 Replies Latest reply on Dec 5, 2014 3:37 AM by Frank Wils

    Calculate Data in DTS



      Has anyone managed to delete a value in a data field using Calculate Data rules in Data Translation Services?

      Have tried a number of standard vbscript values for RetValue including "Null", "0", "Empty" and even "00/00/0000 00:00:00", both with and without the quotes.

      At the moment the only workaround seems to be a ficticious date - 01/01/2100.

      LANDesks interpretation of vbscript is strange in that everything must be in a single line.  A CR will cause the rule to fail.  Also, there appears to be no documentation for this non-standard implementation.

      Any ideas will be most welcome.