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.


Code:
'***********************************************************
'  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
Thanks