Error with nvarchar(max) column

  • 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

  • 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?

  • 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

  • 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