Trouble executing SSIS Package with Excel via Agent

Question

I currently have an SSIS package that exports data from a SQL table to Excel template file.  This file has a dummy row in row one to help with the formatting.  In the package there is a Script Task that deletes the dummy row.  This package works as designed;deleting the row with no issue when executed via BIDS or a standard domain account.  The issue arises when this package is executed via a job using a service account.  It creates the Excel file but does not delete the dummy row.  The weird thing is that if you login to the SQL box with the service account and execute the package via BIDS or outside the job it works like it's supposed to!  I am having a hard time pinpointing what security settings need to be addressed so this can work as designed.

Thanks,

Carlos

Answer 1

Do you receive an error? if yes could you put error message here?

another thought : maybe this is 32 bit / 64 bit problem , did you tried to set Run 32 bit runtime in job step execution tab?

---

http://www.rad.pasfu.com

Answer 2

No errors, file is created but dummy row is not removed.  Agent is setup to execute as 32 bit.

Answer 3

what happen if you try to run package with DTEXECUI ? any difference?

---

http://www.rad.pasfu.com

Answer 4

Hi Carlos-Gonzalez,

I suggest you specify the Windows domain account in which the SQL Server Agent service runs. We recommend choosing a Windows user account that is not a member of the Windows Administrators group. However, there are limitations for using multiserver administration when the SQL Server Agent service account is not a member of the local Administrators group. For more information, see 'Supported Service Account Types' in the following article:

Select an Account for the SQL Server Agent Service: http://msdn.microsoft.com/en-us/library/ms191543.aspx 

Thanks,
Eileen

TechNet Subscriber Support

If you are TechNet Subscription user and have any feedback on our support quality, please send your feedback here.