Post reply

SSIS package execution using proxy account

  • December 5, 2012 at 12:16 pm

    #271211

    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 ?

  • December 6, 2012 at 12:21 am

    #1566028

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

    Need an answer? No, you need a question
    My blog at https://sqlkover.com.
    MCSE Business Intelligence - Microsoft Data Platform MVP

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply