[Origianlly posted by]: https://social.msdn.microsoft.com/Forums/sqlserver/en-US/de21545f-9733-4a86-bd54-3891fe08ce55/the-value-violated-the-schemas-constraint-for-the-columncannot-able-to-upload-4000-length-data?forum=sqlintegrationservices
I am not able to upload data into excel 2007. I have created package is SSIS and I have used OLEDB destination to connect Excel 2007 file. When I am trying to export data into excel 2007 its giving error like The Value voilated Constraint of the column. My table has one column URL with NVARCHAR(Max) Data Type. I have converted this column data type into NText data type using data conversion and from that conversion it will connect EXcel 2007 file.
The URL column contains minimum length of 2000 it means all rows are greater than 255 characters. I have verified the advaned tab of Excel 2007 destination connection it has taking DT_WSTR 255 by default. Can any one please help out how can we export data more than 255 characters in length. In my case there are no rows less than 255 character length.