Viewing 3 posts - 31 through 33 (of 33 total)
I tried this ...
its not working for me..
TRIM([STARTD_CVV] ) == FINDSTRING( STARTD_CVV, "-", 1 ) ? (DT_STR, 8, 1252)NULL(DT_STR,8, 1252) :[STARTD_CVV]
July 15, 2010 at 5:31 am
#1193374
Thanks Phil ,
But i am Novice to SSIS ..Can you tell me how to do it in derived columns ..what about the other columns ..they also need conversion ..so can...
July 15, 2010 at 4:57 am
#1193365
Yes , i changed the properties of excel connection manager but still can't load the leading zeros..
July 14, 2010 at 9:11 am
#1192895