Thomas LeBlanc

Thomas LeBlanc is a Business Intelligence Consultant/Data Warehouse Architect in Baton Rouge, Louisiana. He uses his 25+ years in IT to help develop OLTP systems with normalized databases for high-performing T-SQL and end-to-end dimensional data marts using SSIS, SSAS, PPS, and Excel. His SQL Server certifications include MCSA 12, MCITP 08 BI and DBA, MCITP 2005 DBA, and MCDBA 2000. As a PASS volunteer, he is current chair of the Excel BI virtual chapter, past chair of the Data Architecture virtual chapter, and past virtual chapter mentor. He has helped the Baton Rouge SQL Server User Group with SQLSaturdays and speaks at local IT meetings.

Interests: #SQLFamily

All authors

Solving an SSIS Error – Cannot convert between Unicode and non-Unicode

by Thomas LeBlanc

SQLServerCentral.com

Integration Services (SSIS)

When loading data with SSIS, sometimes there are various errors that may crop up. This article provides a solution when you get have a problem between Unicode and non-Unicode fields.