View Single Post
  #1 (permalink)  
Old November 21st, 2006, 08:35 AM
atulmar atulmar is offline
Authorized User
 
Join Date: Mar 2005
Location: , , India.
Posts: 22
Thanks: 0
Thanked 0 Times in 0 Posts
Default 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
__________________
SQL Technical Consultant
Reply With Quote