How to remove the password for SSIS package

Question

How to remove the password for SSIS package

D Venkatesh 0

I want to delete the password for existing ssis packages.

Yitzhak Khabinsky 26,586 Reputation points

2023-01-23T15:47:50.8266667+00:00

Please clarify what password you are talking about.

Is it about ProtectionLevel setting?
Michael Taylor 60,161 Reputation points

2023-01-23T16:13:24.33+00:00

Please provide more information. What password? On a connection, to deploy the package, what? The more information you provide us the quicker you can get an answer.
ZoeHui-MSFT 41,491 Reputation points

2023-01-24T01:33:37.3966667+00:00

Hi @D venkatesh

What do you mean of the password? Are you using protectionleve in package?

If so, please check Access Control for Sensitive Data in Packages. If not, please give more details.
ZoeHui-MSFT 41,491 Reputation points

2023-01-25T06:46:19.34+00:00

Do you have further question on this, could we offer more support?

If this helps on your issue, you could mark it as answer so other user with similar problem could see this easier. :)

1 answer

Your answer

Yitzhak Khabinsky 26,586 Reputation points

2023-01-23T15:47:50.8266667+00:00

Please clarify what password you are talking about.

Is it about ProtectionLevel setting?
Michael Taylor 60,161 Reputation points

2023-01-23T16:13:24.33+00:00

Please provide more information. What password? On a connection, to deploy the package, what? The more information you provide us the quicker you can get an answer.
ZoeHui-MSFT 41,491 Reputation points

2023-01-24T01:33:37.3966667+00:00

Hi @D venkatesh

What do you mean of the password? Are you using protectionleve in package?

If so, please check Access Control for Sensitive Data in Packages. If not, please give more details.
ZoeHui-MSFT 41,491 Reputation points

2023-01-25T06:46:19.34+00:00

Do you have further question on this, could we offer more support?

If this helps on your issue, you could mark it as answer so other user with similar problem could see this easier. :)

Answer 1

To remove the password for an existing SSIS package, you can follow these steps:

Open SQL Server Data Tools (SSDT) or SQL Server Management Studio (SSMS) and connect to the SQL Server instance where the SSIS package is located.
Locate the SSIS package in the Solution Explorer or Object Explorer, right-click it, and select "Properties" from the context menu.
In the Properties window, select the "ProtectionLevel" property and set it to "DontSaveSensitive". This will remove the password protection from the SSIS package.
Save and deploy the updated SSIS package.

Note that removing the password protection may expose sensitive information in the SSIS package. If you need to protect the sensitive information, you can use other protection options such as Windows Authentication or EncryptSensitiveWithUserKey protection level.

Share via

How to remove the password for SSIS package

1 answer

Your answer