Home Forums SQL Server 2005 SQL Server 2005 Integration Services SSIS Package to create Excel Spreadsheet fails in SQL Agent RE: SSIS Package to create Excel Spreadsheet fails in SQL Agent
Muthamil_c
SSC Enthusiast
Points: 100
More actions
April 26, 2010 at 6:04 am
#1157548
if you use microsoft.interop.excel then only admin and the system user had the permission to generate the excel.so create a proxy account and call the job through that account.