Many thanks for your reply.
As mentioned earlier, I am loading the data from an excel using a SSIS package. I use a SQL task to load the data. Below is the SQL Script which does the actual job -
INSERT INTO [xxxTable]
SELECT * FROM OPENDATASOURCE ('Microsoft.Jet.OleDB.4.0',
'Data Source=E:\Test\currentplaylist.xls; extended Properties=Excel 8.0')...cumulative$
WHERE [FILE #] is not null
The field 'Rate' is the Decimal field. Can you please help me out how can I use the data conversion in this case?