Wednesday, July 11, 2012 11:04 PM
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.
Thursday, July 12, 2012 1:28 AMModerator
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?
Thursday, July 12, 2012 1:33 AMNo errors, file is created but dummy row is not removed. Agent is setup to execute as 32 bit.
Thursday, July 12, 2012 4:18 AMModeratorwhat happen if you try to run package with DTEXECUI ? any difference?
- Proposed As Answer by Eileen ZhaoMicrosoft Contingent Staff, Moderator Sunday, July 15, 2012 1:33 AM
Wednesday, July 18, 2012 10:19 AMModerator
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
TechNet Subscriber Support
- Marked As Answer by Eileen ZhaoMicrosoft Contingent Staff, Moderator Thursday, July 26, 2012 7:18 AM