Hi guys
i have two tables the source and destination. When i import the source data to table in SQL just want only the data (see line bold)that are beetwen "590000*" and "59010*". The problem is that this field is a char one and when i put * it doesn´t return what i need.
ThanksCode:'***********************************************************
' Visual Basic Transformation Script
' Copy each source column to the
' destination column
'***********************************************************
Function Main()
DTSDestination("Moeda") = Right (DTSSource("MVPLN"),3)
DTSDestination("Conta") = DTSSource("MVCNTA")
DTSDestination("Data_Movimento") = DTSSource("MVDTMV")
DTSDestination("Valor") = DTSSource("MVVLR")
DTSDestination("Hora") = DTSSource("MVHORA")
DTSDestination("Data") = DTSSource("MVDTGR")
Main = DTSTransformStat_OK
End Function
