February 25, 2008 at 9:47 am
I'm trying to create a package tha exports from a SQL 2005 table to an Excel file. Everything is working fine until I try to add a notes column which is a text column. I'm receiving the following error when I add this column to the transfromation:
Error: 0xC0202025 at Load Data, Excel Destination [2789]: Cannot create an OLE DB accessor. Verify that the column metadata is valid.
If I remove the column then there is no issue in the data export. There is a data conversion also happening for this field along with some other varchar fields. All varchar fields to unicode string and text field to unicode text.
Can somebody help me to sort this problem out.
Rgds
Sheni
February 25, 2008 at 10:11 am
Try converting the text column to varchar()
max) in your query. The. Text datatype is stored as binary in SQL Server.
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
February 28, 2008 at 4:28 am
I had the same problem.
I did an export from sql-server to an excel-file with a package. De colomnheaders where already placed in this file. I wasn't able to export the sql.text field without an error, so i changed the package like this: The 'table' in excel, i.e. the headers, was created during the export. This works fine. Excel then creates another type of field. So start with an empty excel file an create the headers during the running of the package.
Regards Patrick van Kaam
Viewing 4 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply