I am running an SSIS package that pulls data from one SQL server to other SQL Server. The source and destination table has same schema. One of the column is of nvarchar(max) datatype. When I'm trying to insert the data - it is giving me following error for the nvarchar(max) type column-
Error: SSIS Error Code DTS_E_OLEDBERROR. An OLE DB error has occurred. Error code: 0x80004005. An OLE DB record is available. Source: "Microsoft SQL Server Native Client 11.0" Hresult: 0x80004005 Description: "Unicode data is odd byte size for column 13. Should be even byte size.".
Can someone help me to resolve this issue?
Nvarchar Max
gives this error, try using a fixed length instead ofNavarchar Max
or use integer type – Ven