I resolved this issue ..

solution for this issue is ..instead of taking the sqlserver destination use oledb destination for oledb connection.

..regards

mallik