Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2008 Forums
 SSIS and Import/Export (2008)
 Unable to export XLSX file with 0.5 million record

Author  Topic 

ekannan82
Starting Member

1 Post

Posted - 2012-03-18 : 11:24:11
When i trying to export 10 million records from data reader(Query executed in sql and returned resultset) into Excel(XLSX) file. I am getting error as "File corrupted"/records are not inserting.

Script task inserting one by one rows into excel in SSIS.

Please advice is there any alternative method or bulk export into XLSX file from SSIS

Note: I am creating DYNAMIC columns in Excel file.

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2012-03-18 : 12:40:37
yep. you can try using an execute sql task and use OPENROWSET inside that to read the records from excel as a batch


http://msdn.microsoft.com/en-us/library/ms190312.aspx


------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/

Go to Top of Page
   

- Advertisement -