Hi there, i need to insert records from an excel file to a sql database,
On excel i have a column with this number format:
44556612345677, i need to insert into sql2005 only the 12345677, i dont need this:445566;
and another column in excel has this format:
1234567, and i need to insert in sql like this:00001234567

i tryed to use the SSIS and this function with derived columns but not working.

this is the expression i tryed:
right([Connecting Phone Number] , LENGTH([Connecting Phone Number] ) - 6) '0000' + right([Current Phone Number], LENGTH([Current Phone Number]) - 6) as [Current Phone Number]





thanks

__________________
bx