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]

([ID],[Loop],[Name],[Inserted],[Deleted],[Contract],[Start_Date],[End_Date],[Num_of_Ads],[Rate],[Advertiser],[Agency],[Product])

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?

Thanks Again,

Sumon