FTP connection getting failed.

Jinal Contractor 121 Reputation points
2022-01-21T00:35:44.947+00:00

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.

SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,463 questions
0 comments No comments
{count} votes

2 answers

Sort by: Most helpful
  1. Yitzhak Khabinsky 25,201 Reputation points
    2022-01-21T00:54:47.963+00:00

    Hi @Jinal Contractor ,

    Please try to change SSIS package ProtectionLevel value to DontSaveSensitive.

    Check it out: ssis-package-protection-level


  2. ZoeHui-MSFT 33,386 Reputation points
    2022-01-21T03:08:27.277+00:00

    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.

    0 comments No comments