Wrox Programmer Forums
BOOK: Professional SQL Server 2005 Integration Services ISBN: 0-7645-8435-9
This is the forum to discuss the Wrox book Professional SQL Server 2005 Integration Services by Brian Knight, Allan Mitchell, Darren Green, Douglas Hinson, Kathi Kellenberger, Andy Leonard, Erik Veerman, Jason Gerard, Haidong Ji, Mike Murphy; ISBN: 9780764584350
Welcome to the p2p.wrox.com Forums.

You are currently viewing the BOOK: Professional SQL Server 2005 Integration Services ISBN: 0-7645-8435-9 section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
Old March 31st, 2008, 02:53 PM
Registered User
Join Date: Mar 2008
Posts: 2
Thanks: 0
Thanked 0 Times in 0 Posts
Default UNICODE Conversion in Excel

I'm working in the Exporting to Excel section of chapter 8. I'm not using the AdventureWorks database, but rather the reporting database here at work.

When I run the package, I get the following error:
'Error at Data Flow Task [Excel Destination [16]]: Column "status" cannot convert between unicode and non-unicode string data types.' This message repeats for all string type fields. I've gone so far as to try the data conversion transformation.

Any help would be appreciated.


Old March 31st, 2008, 04:20 PM
Registered User
Join Date: Dec 2007
Posts: 5
Thanks: 0
Thanked 0 Times in 0 Posts

I am reading p. 61 of the book "Expert SQL Server 2005 Integration Services" and it says there is a 255-character limitation when extracting cells and the excel 97-2005 provider is used. It also says this limitation has been overcome in the Office 2007 provider.

Similar Threads
Thread Thread Starter Forum Replies Last Post
access to excel sheet conversion? ramniwas Visual Basic 2005 Basics 2 April 6th, 2008 08:38 AM
Getting Unicode From Excel nullGumby Access VBA 1 December 1st, 2006 07:02 PM
Excel Conversion echovue Excel VBA 2 December 13th, 2005 12:44 PM
Problem in Conversion from XML to Excel nabeela_noor XML 1 January 14th, 2005 11:24 AM
unicode soodamanir C++ Programming 1 September 20th, 2004 09:02 AM

Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.