I have created a proxy account using sql server agent to run my ssis package in the production environment. when i create a proxy account with my credentials i have no issues running the job. The issue comes when ever i create a proxy with sql admin account the job fails and if i run the package with sql server agent even then the job fails. from the below fig if i use identity as my credentials job runs fine. if i use identity sql admin credentials it fails. i double checked the sql server roles and it is pointed to admin Can some one help me to resolve this issue. my requirement is to run the job with sqladmin or sqlserver agent not my credentials. -Thanks in advancenethan

1) Fails with what error? 2) Is the SQL admin account a domain account?Chuck

Thanks for your response chuck. SQL admin is a domain account. and here is the error message. Executed as user: INSURANCE\sqladmin. Microsoft (R) SQL Server Execute Package Utility Version 10.50.2425.0 for 32-bit Copyright (C) Microsoft Corporation 2010. All rights reserved. Started: 1:23:30 PM Error: 2012-05-21 13:23:30.85 Code: 0xC0016016 Source: Description: Failed to decrypt protected XML node "DTS:Password" with error 0x8009000B "Key not valid for use in specified state.". You may not be authorized to access this information. This error occurs when there is a cryptographic error. Verify that the correct key is available. End Error Error: 2012-05-21 13:23:32.46 Code: 0xC0029151 Source: FTP (Download) INH05, INH07 Execute Process Task Description: In Executing "C:\Program Files (x86)\WinSCP\WinSCP.com" "-script=D:\SSISDependencies\OAKS\OaksGetINH0507.txt" at "D:\SSISProcessing\OAKS\", The process exit code was "1" while the expected was "0". End Error DTExec: The package execution returned DTSER_FAILURE (1). Started: 1:23:30 PM Finished: 1:23:32 PM Elapsed: 2.449 seconds. The package execution failed. The step failed. The job runs fine with my credentials. - Thanks nethan

Ah, that is an easy one. You need to change the protection level on your package. You currently have it set to the default of EncryptSensativeWithUserKey. Open it up in bids and change it to DontSaveSensative and ensure that you are providing any hard coded passwords via a config. The reason it works on your ID is that you developed it so your ID can decode whatever password it thinks is embedded in the package. Any other account causes an error Chuck

Thanks again Chuck Still getting the following error. Cool first error disappered Message Executed as user: INSURANCE\sqladmin. Microsoft (R) SQL Server Execute Package Utility Version 10.50.2425.0 for 32-bit Copyright (C) Microsoft Corporation 2010. All rights reserved. Started: 11:33:43 AM Error: 2012-05-22 11:33:46.18 Code: 0xC0029151 Source: FTP (Download) INH05, INH07 Execute Process Task Description: In Executing "C:\Program Files (x86)\WinSCP\WinSCP.com" "-script=D:\SSISDependencies\OAKS\OaksGetINH0507.txt" at "D:\SSISProcessing\OAKS\", The process exit code was "1" while the expected was "0". End Error DTExec: The package execution returned DTSER_FAILURE (1). Started: 11:33:43 AM Finished: 11:33:46 AM Elapsed: 2.449 seconds. The package execution failed. The step failed. -Thanksnethan

WINCP is telling you that your command line is bad. Are those d:\ paths actual paths or mapped drives?Chuck

Yes they are the actual paths Same package runs fine if i use the proxy account with my credenials and even if i run the package using BIDS i found no issues. only while scheduling, the error msg pops up. the error wont show up when i use the proxy account "Identity" provided my credentials,( fig in above thread). Thanksnethan

Is there any sort of authentication to the FTP server that might be causing the issue? ie - your account has permissions and the other does not?Chuck