Don't think it was a "waist" (sic) of time at all.  If you can guarantee in a multi-developer situation that nobody has tinkered with at DTS package on a live server,...

Are these columns really Null?

I would suggest:

function Main()

{

  if (DTSSource("Col009") == "")

  {

    DTSDestination("CLO") = DTSSource("Col010");

  }

  else

  {

    DTSDestination("CLO") = DTSSource("Col009");

  }

  return(DTSTransformStat_OK);

}