im getting this error in SSIS to import to CSV file. i tried XLS file same issue. how can i solve this? already try to increase the output column width but still same error.
error:[Flat File Destination 1 ] Error: Data conversion failed. The data conversion for column "column1" returned status value 4 and status text "Text was truncated or one or more characters had no match in the target code page.".
select * from ( select convert(nvarchar(100),'column1')column1,1 as ordering union all select convert(nvarchar(100),column1) column1,2 as ordering from tableA )x order by ordering