Post reply

DTS - Math in VB Script doing crazy stuff

  • September 13, 2004 at 11:31 am

    #59324

    When I add the line:

    DTSDestination("X") = DTSSource("L") - DTSSource("M")

    I get odd results in my output ... no error just no number in the resulting field and following blank records.  Any idea why?

  • September 14, 2004 at 5:59 am

    #522925

    Check the data types of each field.  You may have implicit conversion going on here where the minus operator is not performing a math function.

  • September 14, 2004 at 7:02 am

    #522947

    Thanks.  The problem is that one value in the calculation was null ... I just did a check first.  THANKS!!!! for the reply though : )

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

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