rajeshpalo2003 78748 (12/19/2012)
if data will be more than 1.5 millions,then what is solution for this?because i have 1.6 millions of records.
Please suggest me....
You can use for example two OLE DB sources with Data access mode: sql command. You can make two selects: one selecting the first million rows and the other selecting the rest 0.6 million rows.
Export both sets into two different excel documents or sheets.
There are more ways to do your task.
SQL Server developer at Seavus