Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase ««12

Am not able to export 10 lakh records to excel sheet. Expand / Collapse
Author
Message
Posted Thursday, January 10, 2013 10:19 PM


SSCoach

SSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoach

Group: General Forum Members
Last Login: Yesterday @ 3:20 PM
Points: 18,064, Visits: 16,099
That is good to hear.



Jason AKA CirqueDeSQLeil
I have given a name to my pain...
MCM SQL Server, MVP


SQL RNNR

Posting Performance Based Questions - Gail Shaw
Post #1405761
Posted Thursday, January 10, 2013 11:08 PM


Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Friday, November 21, 2014 8:48 AM
Points: 323, Visits: 986
ravi@sql (1/10/2013)

Hi thank you all for the support.

Finally i exported data using SSIS and it works fine .

Regards,
Ravindranath.s




can u please explain how ?

because for excel 2007 ,row limit is 10,00,000 and you mentioned that there are 11,00,000 + records in table.


-----------------------------------------------------------------------------
संकेत कोकणे
Post #1405765
Posted Thursday, January 10, 2013 11:15 PM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Monday, May 26, 2014 6:02 AM
Points: 93, Visits: 195

No actually i exported 3 lakh records with around 150 columns dude , i splitted the records based on source using query . for that only it was taking around 1.5 hour to export.



Post #1405771
Posted Thursday, January 10, 2013 11:29 PM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Wednesday, December 17, 2014 2:16 AM
Points: 2,840, Visits: 3,983
ravi@sql (1/10/2013)

No actually i exported 3 lakh records with around 150 columns dude , i splitted the records based on source using query . for that only it was taking around 1.5 hour to export.
it will/should as data transfer rate will be dependent on certain factor like cpu, memory and IO.


-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done
Post #1405775
« Prev Topic | Next Topic »

Add to briefcase ««12

Permissions Expand / Collapse