OK.... Thanks.... :satisfied::laugh:

Phil,

This is my scenario...

I've one excel file, in that file i've one column called Allowance which has only numeric values if it is 0 then the user will enter "-"...

Thanks Sasidhar...... It worked.......

Is there any sql statement available to replace the all the special characters(ie, Other than Numeric) to "0"?

Yes.. the data type of the derived column is float.....

In the expression... I convert the Allowance to string to check with the "-"...

In Source SQL table it is varchar(10) and in Destination it is float.....

Sasidhar... I'll try your idea and let you know... Thanks