May 18, 2006 at 3:53 pm
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 an nvarchar(max) 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.
Does anyone know what could be causing this error?
Wendy Schuman
May 19, 2006 at 7:27 am
Just a thought.
There is a limit to the number of characters that can be stored in an Excel cell. I think it is 32768. Could this be your problem?
May 19, 2006 at 8:39 am
Currently I'm working with test data which is far less than the 32,768 limit for an Excel cell. When we work with the live data, it will be a problem for a few records and we will have to manually add that data to the file.
Wendy Schuman
May 23, 2006 at 10:49 am
I rebooted my machine, created a new package and no longer receive the Ole DB accessor error. I also went back and executed the previous packages that were giving me the error and they ran fine.
Wendy Schuman
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply