Unable to create an excel file using Excel Destination -SSIS

G Ram
G Ram used Ask the Experts™
on
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 [83]] 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.
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
lcohanDatabase Analyst

Commented:
Would it be possible/acceptable to try the SSIS export to CSV instead considering the data type and size of columns to be exported?

Author

Commented:
No, I found that if I delete the excel connector and recreated this error goes away. Probably it’s still thinking it’s in use. And importantly if I create a dummy row that has data close to size the dB has, it works without any issue , obviously I have to delete that row before I use the excel generated. Xls still thinks it’s 255 for every nvarchar column
Admin.. please note that solution was fiund

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial