p2p.wrox.com Forums

p2p.wrox.com Forums (http://p2p.wrox.com/)
-   Reporting Services (http://p2p.wrox.com/reporting-services-205/)
-   -   Exporting data into Excel file from SSIS (http://p2p.wrox.com/reporting-services/50564-exporting-data-into-excel-file-ssis.html)

atulmar November 21st, 2006 08:35 AM

Exporting data into Excel file from SSIS
 
I am using Office 2007 beta. I have a SSIS package that exports the records from sql server to excel file, when number of records is less than 24000 then it exports well, but if number of records is greater than 24000 than it does not export anything to excel file.

But when I give administrative privilages to the service account under which the SSIS package is running, it export even more than 24000.

On prod server giving administrative privilages to service account is not a good option. I don't know what are the minimum permissions it needs while exporting more data into excel 2007 file.

Thanks in advance.

Atul


SQL Technical Consultant


All times are GMT -4. The time now is 04:22 AM.

Powered by vBulletin®
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
2013 John Wiley & Sons, Inc.