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
Discuss This Question: