I found a work around for this problem. I imported the data into Access database first and then imported it into SQL database successfully.

Thanks

Priya

Hi Jack,

I am inserting the values into a nvarchar(2000) column. All i am doing is, right click the database, select the import option, select the source and destination then do...