Hi Drew,

Thanks for the reply. I will try that.

thanks for all of your support i got the solution.

actually in the import file list the date format is the conflict.It is going to update statement and updating 09-feb-2008 instead...

thanks for the replies.

here is the sql profiler trace

exec Phone_Insert @Extension='901 ',

@CallDate=''2008-02-09 00:00:00:000'',

@Calltime=''1900-01-01 16:25:28:000'',

@Phone='9869313128',

@Duration=$0.1000,

@Trunk=702,

@calls=1,

@cost=$0.8500,

@CallType='Local'

if we execute in the sqlserver query window it is showing error...