Hello SSC, I need help to perform an import from share point list to sql table. I am using SSIS for this. Sql server 2012 and Visual Studio is 2010. I have setup connection from Share Point Source to Sql Server Destination.I have tried using data conversion and derived column as well. But data appears as below in SQL table: Class Cert Discovery Complete (~130,000 pages) Inactive - Pending2dCir. Where as in share point list it is like below: College degree Discovery Complete (~130,000 pages)Inactive - Pending 2d Cir Pl let me know if I am missing something OR if I should use some tool to clean off data. Thanks in advance PS: Message is not allowing to show HTML tags in question.