itzmee (2/5/2010)
Hi, Thanks for your reply. Please explain how to do that..
Right-click your Excel Source, and select "Show Advanced Editor".
Go the the "Input and Output Properties" tab.
Expand the "Excel Source Output" node.
Expand the "External Columns" and "Output Columns" nodes.
Click on the appropriate column under "External Columns".
Change DataType to "Unicode Text Stream".
Click on the appropriate column under "Output Columns".
Change DataTYpe to "Unicode Text Stream".
Click "Ok".
Wayne
Microsoft Certified Master: SQL Server 2008
Author - SQL Server T-SQL Recipes