SSIS package execution using proxy account

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2008 » SQL Server 2008 High Availability » SSIS package execution using proxy account

SSIS package execution using proxy account

Rate Topic

Display Mode

Topic Options

Author

Message

Prem-321257

Posted Wednesday, December 05, 2012 12:16 PM

Grasshopper

Group: General Forum Members
Last Login: Tuesday, May 21, 2013 3:04 PM
Points: 20, Visits: 190

Unusal issue during SSIS package execution using proxy account. I am guessing it is related to memory issue on the server. Any help is appreciated ?

I setup a proxy account and all permissions looks good. If I execute the job say for 10 million records. The job runs successfully.

The same job for 33 millions records failes but if I change the job to be executed by SQL service account it runs successfully. Below is the log information :

Log of proxy account run.

OnProgress,<servername><proxyaccountname>,Move data to test table,{3F1D1769-1235-4807-A78B-91D13099DEB0},{9F3C3178-1C41-4121-A066-FB30C2E64034},12/4/2012 4:20:57 PM,12/4/2012 4:20:57 PM,100,0x,Cleanup

OnWarning,<servername><proxyaccountname>,Move data to test table,{3F1D1769-1235-4807-A78B-91D13099DEB0},{9F3C3178-1C41-4121-A066-FB30C2E64034},12/4/2012 4:20:57 PM,12/4/2012 4:20:57 PM,-2147381246,0x,SSIS Warning Code DTS_W_MAXIMUMERRORCOUNTREACHED. The Execution method succeeded, but the number of errors raised (183) reached the maximum allowed (1); resulting in failure. This occurs when the number of errors reaches the number specified in MaximumErrorCount. Change the MaximumErrorCount or fix the errors.

Log of sql service account run.

PM,50,0x,Cleanup
OnProgress,LDWZD5567,,<servername><proxyaccountname>,,Move data to test table,{3F1D1769-1235-4807-A78B-91D13099DEB0},{60DD909C-BA5D-48EA-AA59-36381A5CB9DB},11/29/2012 2:10:25 PM,11/29/2012 2:10:25 PM,100,0x,Cleanup

OnPostExecute,,<servername><proxyaccountname>,,Move data to test table,{3F1D1769-1235-4807-A78B-91D13099DEB0},{60DD909C-BA5D-48EA-AA59-36381A5CB9DB},11/29/2012 2:10:25 PM,11/29/2012 2:10:25 PM,0,0x,(null)

Based on the log - the cleanup phase failes. Any suggestions ?

Post #1393165

Koen Verbeeck

Posted Thursday, December 06, 2012 12:21 AM

SSCrazy Eights

Group: General Forum Members
Last Login: Yesterday @ 2:11 AM
Points: 9,378, Visits: 6,473

I don't see any actual errors. What does the SQL Server Agent log say?

How to post forum questions.
Need an answer? No, you need a question.
What’s the deal with Excel & SSIS?

Member of LinkedIn. My blog at LessThanDot.

MCSA SQL Server 2012 - MCSE Business Intelligence

Post #1393346

« Prev Topic | Next Topic »

Permissions