The column status returned was The value violated the schema's constraint for the column

0

I have a SQL Server table column with length as nvarchar(2000). Wanted to transfer the data to Excel file 2007 using SSIS.

What i did

enter image description here

Source column Data type is Nvarchar(2000) which is DT_NTEXT on SSIS. on Excel the column Datatype is Nvarchar(255)

Below blue color circled Columns are giving me troubles.

Source MetaData

enter image description here

What can we do to take the whole source column data into one cell in the excel column?

The error I'm getting an error

ERROR

[Excel Destination [8]] Error: SSIS Error Code DTS_E_OLEDBERROR. An OLE DB error has occurred. Error code: 0x00040EDA. An OLE DB record is available. Source: "Microsoft Access Database Engine" Hresult: 0x80040E21 Description: "The field is too small to accept the amount of data you attempted to add. Try inserting or pasting less data.".

[Excel Destination 3] Error: There was an error with Excel Destination.Inputs[Excel Destination Input].ColumnsComment] on Excel Destination.Inputs[Excel Destination Input]. The column status returned was: "The value violated the schema's constraint for the column

[Excel Destination 3] Error: SSIS Error Code DTS_E_INDUCEDTRANSFORMFAILUREONERROR. The "Excel Destination.Inputs[Excel Destination Input]" failed because error code 0xC0209076 occurred, and the error row disposition on "Excel Destination.Inputs[Excel Destination Input]" specifies failure on error. An error occurred on the specified object of the specified component. There may be error messages posted before this with more information about the failure.

How can i overcome this problem.

sql
sql-server
excel
ssis
sqldatatypes
asked on Stack Overflow Aug 27, 2020 by Bumblebee • edited Aug 28, 2020 by Bumblebee

0 Answers

Nobody has answered this question yet.


User contributions licensed under CC BY-SA 3.0