could you please any one provide solution for this problem.... using ssis, i am loading the data from flat file(text file) to Excel destination. source has two columns: empid empdata(nearly 2,50,000) i got the error that size exceeds for inserting that data because each cell having the capacity of 32,765 in excel 2007. Am also used excel 2010 also ,same problem repeted? please provide a solution foe me...

Excel has a limitation of 10,48,576 rows (2007 &2010). So your data is well below the limit (2,50,000). Make these changes, Go to your Flat file source and right click and select Advanced editorGo to input and output properties and select output columnYou will find all the columns, click on empdataIn data type properties you will find data type and sizeBy default size will be 50 for string, increase the size depending on your data to 100 or 200Re run your package I think this will solve your problem Regards, YB

Excel has a limitation of 10,48,576 rows (2007 &2010). So your data is well below the limit (2,50,000). Make these changes, Go to your Flat file source and right click and select Advanced editorGo to input and output properties and select output columnYou will find all the columns, click on empdataIn data type properties you will find data type and sizeBy default size will be 50 for string, increase the size depending on your data to 100 or 200Re run your package I think this will solve your problem Regards, YB

the problem is in the source (text file) emp data is 2,50,000 rows,we have to insert that total data into excel field(each) empid empdata(nearly 2,00,000 rows 1 aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa 2 bbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbb now we want insert it into excel dest as empid-----empid empdata-----empdata

tnrav, The number I perceive is 250 thousand rows (250K/250,000 in North American formatting or 250000 in the rest of the world I believe). In Excel 2003 and 2007 the # of rows is limited to 65K+, Excel 2010 has this limit set at 1M (1 Million) rows. I do not understand if you hit the number or rows limit or the column width? Asking because I see a long cell. The cell can only accept 255 chars. Awaiting clarifications.Arthur My Blog

yes how we can insert more than 255 characters into a cell in excel file

I have seen that it is possible to insert > than 255 chars, but the chars from 256 position I recall not editable, in any case, in short, you cannot and should not. I trust your design should not involve Excel at all.Arthur My Blog