• Sorry, I typed the assignment operator ( = ) instead of the equals operator ( == ).  Corrected code is shown below:

    function Main()

    {

      var c9 = DTSSource("Col009")

      var c10 = DTSSource("Col010")

      if (c9 == null || c9 == "null")

        c9 = "";

      if (c10 == null || c9 == "null")

        c10 = "";

      DTSDestination("CLO") = c9 + c10;

      return(DTSTransformStat_OK);

    }

    Mike