I've looked at http://www.sqldts.com/default.aspx?293 and played with the
Allow Idenity Insert check but still having the sameproblem

Function Main()

DTSDestination("Order/Propref") = DTSSource("col002")
DTSDestination("Date") = DTSSource("col003")
DTSDestination("Details") = "Na1:" + DTSSource("col003") + " Na2:" +
DTSSource("col004") + " App1:" + DTSSource("col005") + " App2:" +
DTSSource("col006") + " Att1:" + DTSSource("col007")
DTSDestination("Error") = DTSSource("col012")

Main = DTSTransformStat_OK
End Function

Any ideas ?