Trouble executing SSIS Package with Excel via Agent
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
July 11th, 2012 7:04pm
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
Free Windows Admin Tool Kit Click here and download it now
July 11th, 2012 9:28pm
No errors, file is created but dummy row is not removed. Agent is setup to execute as 32 bit.
July 11th, 2012 9:33pm
what happen if you try to run package with DTEXECUI ? any difference?http://www.rad.pasfu.com
Free Windows Admin Tool Kit Click here and download it now
July 12th, 2012 12:18am
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.
July 18th, 2012 6:19am