i am loading data from database to excel files. but after loading 900000 it getting error illegal argument exceed limit.
below is the screen shot lease find it.
As Excel has a maximum of 64K rows, I dont think you can do what you need - though a setting in the component may allow it (see link).
@karthik_T,check below links may be useful to split.
@karthik_T,please accept the solution,which one is helped you.
SSRS 2008R2 supports the .xls file extension for Excel, but these Excel files support a maximum of 65,536 records per sheet. When you try to export a SSRSreport which has more than 65,536 records it will fail to export the report intoExcel.J tinklepad movies | IMO Free Download For Windows | flixnet kodi | kissanime mobile | Tubemate For PC | Download My Talking Tom For PC
Talend named a Leader.
Kickstart your first data integration and ETL projects.
Watch the recorded webinar!
Learn how to do cool things with Context Variables
Find out how to migrate from one database to another using the Dynamic schema
Pick up some tips and tricks with Context Variables