This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(83.2, 72%, 18%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJC%3C/text%3E%3C/svg%3E)
Hello<
I'm trying to send data to FTP server using SSIS and getting below error.
I've SQL Server 2012 and Visual Studio 2017. Has anyone seen this error before if so please guide through issue.
THank you
Microsoft (R) SQL Server Execute Package Utility Version 13.0.5888.11 for 64-bit Copyright (C) 2016 Microsoft. All rights reserved. Started: 6:28:04 PM Error: 2022-01-20 18:28:05.51 Code: 0xC0016016 Source: Package Description: Failed to decrypt protected XML node "DTS:Property" 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: 2022-01-20 18:31:39.67 Code: 0xC001602A Source: Package Connection manager "FTP Connection Manager" Description: An error occurred in the requested FTP operation. Detailed error description: The password was not allowed End Error Error: 2022-01-20 18:31:39.67 Code: 0xC002918F Source: FTP Task FTP Task Description: Unable to connect to FTP server using "FTP Connection Manager". End Error DTExec: The package execution returned DTSER_FAILURE (1). Started: 6:28:04 PM Finished: 6:31:39 PM Elapsed: 214.953 seconds. The package execution failed. The step failed.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(96, 26%, 19%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EYK%3C/text%3E%3C/svg%3E)
Hi @Jinal Contractor ,
Please try to change SSIS package ProtectionLevel value to DontSaveSensitive.
Check it out: ssis-package-protection-level
Hello I just tried DontSaveSensitive and getting below error regarding FTP connection.
But I test the connection on FTP which is success and I can able to read destination folder on FTP server as well.
Microsoft (R) SQL Server Execute Package Utility Version 13.0.5888.11 for 64-bit Copyright (C) 2016 Microsoft. All rights reserved. Started: 7:20:25 PM Error: 2022-01-20 19:20:31.37 Code: 0xC001602A Source: Package Connection manager "FTP Connection Manager" Description: An error occurred in the requested FTP operation. Detailed error description: The password was not allowed End Error Error: 2022-01-20 19:20:31.38 Code: 0xC002918F Source: FTP Task FTP Task Description: Unable to connect to FTP server using "FTP Connection Manager". End Error DTExec: The package execution returned DTSER_FAILURE (1). Started: 7:20:25 PM Finished: 7:20:31 PM Elapsed: 5.437 seconds. The package execution failed. The step failed.
Hi @Jinal Contractor ,
If your package protection level is EncryptSensitiveWithUserKey, change the package protection level to EncryptSensitiveWithPassword.
When configuring the Agent Job Step, after you have selected the package, click on the Configurations tab. You will see a dialog that prompts you to specify a password.
If your package protection level is EncryptSensitiveWithUserKey.
When running the SSIS job step, use a proxy account.
Here is a same thread you may take a reference: ftp-problem-unable-to-connect-to-ftp-server-using-quotftp-connection-managerquot
Regards，
Zoe
If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.