SSIS error - 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.

nononame2021 256 Reputation points
2022-08-06T14:59:41.797+00:00

i am getting the following error when i move the file from local to another network drive. (e.g. //servername/folder/output).

for the database connection:
I stored the database login ID, database name, and database password in variable, and set it to connection manager.

before execution, my ssis account can access the share drive manually and can copy file to that server manually. However, when i run the job auto by sql agent job scheduler. it failed with below error. how to fix it?

Error message: (failed on move file by File System task)

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.
0xC002F304 Source: move file to share folder File System Task

228773-image.png

anyone know how to fix it?

SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,459 questions

5 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Yitzhak Khabinsky 25,111 Reputation points
    2022-08-07T01:14:31.277+00:00

    Hi @nononame2021 ,

    All environment dependency values, i.e. passwords, connection strings, drives, directories, etc. should be externalized via parameters and project level connection strings. So, they should not be stored inside SSIS packages.

    SSIS packages have a property called ProtectionLevel.
    It is better to set its value to DontSaveSensitive

    You can read about it here: securing-your-ssis-packages-using-package-protection-level

  2. nononame2021 256 Reputation points
    2022-08-07T05:23:57.803+00:00

    when i can the protectionlevel to DontSaveSensitive. rebuild the SSIS, it failed with following error.

    Error 1 Project consistency check failed. The following inconsistencies were detected: SSIS_DEV.dtsx has a different ProtectionLevel than the project. 0 0

    how to fix it?

    0 comments
  3. nononame2021 256 Reputation points
    2022-08-07T05:31:47.107+00:00

    my error message:

    Source: Package 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.
    Source: Copy file to client server's folder File System Task Description: An error occurred with the following error message: "The filename, directory name, or volume label syntax is incorrect. ".

    when i use the ssis account, it can go to that directory and can copy file to that directory manually, however, when run it in sql agent job, it failed to move file from local to client's server with above error message.

    anyone know how to resolve it?

    0 comments
  4. nononame2021 256 Reputation points
    2022-08-07T14:27:14.513+00:00

    anyone know how to fix the error ?

    Source: Package 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.
    Source: Copy file to client server's folder File System Task Description: An error occurred with the following error message: "The filename, directory name, or volume label syntax is incorrect. ".

    0 comments
  5. ZoeHui-MSFT 33,211 Reputation points
    2022-08-08T02:53:55.667+00:00

    Hi @nononame2021 ,

    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.

    This behavior occurs when you try to run the SSIS package by using a different computer or a different user account than the computer and user account that were used to create the SSIS package.

    To resolve this behavior, change the value of the ProtectionLevel property in the SSIS package.

    More details you may refer the official documentations:

    error-loading-message-run-integration-services-package

    access-control-for-sensitive-data-in-packages

    Source: Copy file to client server's folder File System Task Description: An error occurred with the following error message: "The filename, directory name, or volume label syntax is incorrect. ".
    when i use the ssis account, it can go to that directory and can copy file to that directory manually, however, when run it in sql agent job, it failed to move file from local to client's server with above error message.

    If the issue only occurs when you run the package via gent job, please consider to use proxy account which have the full permission to the file to run the job.

    Reference: running-a-ssis-package-from-sql-server-agent-using-a-proxy-account

    Regards，

    Zoe

    If the answer is helpful, please click "Accept Answer" and upvote it.

    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.
    Hot issues October

    0 comments