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
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
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.
User contributions licensed under CC BY-SA 3.0