Home > IT Answers > Microsoft Windows > SQL To Excel Data Dumping with the help of SSIS flow task.
Ssis
5 pts.
 SQL To Excel Data Dumping with the help of SSIS flow task.
Excel 2003, Excel Metadata, SQL Server database, SQL to Excel Database Conversion, SSIS Package
I am trying to do a Sql To Excel Data Dumping with the help of ssis flow task.I create a sql connection and give the query in the sql source.I aslo have a excel template to map in excel destination ready which has around 400 columns/fields.In bettween i use a dataconvrsion for unicode/non unicode issue.Now when i run this package i get errors like."excel metadata in nvalid","error creating oledb accessor".....is it due to any limitations dat we cannot populate more that 255 cols/fields in excel(i am using 2003 excel). Please help me with a suggestion

Software/Hardware used:
ASKED: July 18, 2010  3:37 PM
UPDATED: July 19, 2010  1:39 PM
RELATED QUESTIONS
Answer Wiki:
I would think that it is, as older versions of Excel can't handle that much data. You'll need to use a CSV file or a newer version of Excel.
Last Wiki Answer Submitted:  July 18, 2010  9:12 pm  by  Denny Cherry   64,550 pts.
All Answer Wiki Contributors:  Denny Cherry   64,550 pts.
To see all answers submitted to the Answer Wiki: View Answer History.


RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _