Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
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


SSC-Insane

SSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-Insane

Group: General Forum Members
Last Login: Yesterday @ 2:52 PM
Points: 20,083, Visits: 18,257
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: Wednesday, May 11, 2016 11:41 PM
Points: 323, Visits: 1,019
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-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Monday, November 7, 2016 5:08 AM
Points: 127, Visits: 347

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: Tuesday, July 19, 2016 4:34 AM
Points: 2,850, Visits: 4,076
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
Posted Wednesday, September 23, 2015 6:27 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Wednesday, October 21, 2015 3:11 AM
Points: 1, Visits: 31
HI Ravi,

Any idea. Need to export around 1 million.

Thanks,
Rajesh
Post #1722142
Posted Thursday, September 24, 2015 9:41 AM


SSC-Insane

SSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-Insane

Group: General Forum Members
Last Login: Yesterday @ 2:52 PM
Points: 20,083, Visits: 18,257
rajeshkumarN (9/23/2015)
HI Ravi,

Any idea. Need to export around 1 million.

Thanks,
Rajesh


BCP or ssis can do the job for you.




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


SQL RNNR

Posting Performance Based Questions - Gail Shaw
Post #1722664
« Prev Topic | Next Topic »

Add to briefcase ««12

Permissions Expand / Collapse