Home Forums SQL Server 2005 Business Intelligence How to load one million records into excel using ssis RE: How to load one million records into excel using ssis

  • December 19, 2012 at 5:01 am

    #1570001

    rajeshpalo2003 78748 (12/19/2012)

    Thank's IgorMi.

    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....

    Hi,

    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.

    Regards

    IgorMi

    Igor Micev,My blog: www.igormicev.com