How to fix the Non-unicode to unicode data type conversion problems in SQL Server Integration Services?

Problem: Are you trying to import an Excel file into SQL Server using SQL Server Integration services...And ran into error that has words like "Non unicode" and "unicode"? Then this blog is for you. Why does this error occur? Well it turns out that things like SQL Server and Excel have encoding standards that they follow which provides them a way to process, exchange & store data. [ 122 more words. ] http://ift.tt/1M7ZPMf
via Paras Doshi - Blog http://ift.tt/1M7ZPMf
http://ift.tt/WAQ5ky