Exporting a data having nvarchar(4000) and also other fields having nvarchar(2000) onto .xls or .xlsx file using SSIS runs into an issue .Size of 'Column' is too long. If I keep these columns to nvarchar(255) and also set the project property Run64bitRuntime to true,I receive the following error
[Excel Destination ] Error: SSIS Error Code DTS_E_CANNOTACQUIRECONNECTIONFROMCONNECTIONMANAGER. The AcquireConnection method call to the connection manager "Excel Connection Manager" failed with error code 0xC00F9304. There may be error messages posted before this with more information on why the AcquireConnection method call failed.