有一个选项:在信息复制到目的时候进行转换
如:
**********************************************************************
' Visual Basic Transformation Script
' Copy each source column to the
' destination column
'************************************************************************
Function Main()
DTSDestination("STATEMENT_ID") = DTSSource("S_ID")
DTSDestination("TIMESTAMP") = DTSSource("TIMESTAMP")
DTSDestination("REMARKS") = DTSSource("REMARKS")
DTSDestination("OPERATION") = DTSSource("OPERATION")
Main = DTSTransformStat_OK
End Function