Share via

TFS: Checking in SSIS Packages and removing credentials

Tony Scott 0 Reputation points
2024-10-01T18:57:30.8066667+00:00

Our team use TFS for source control, for various objects, including SSIS packages.

Those SSIS packages will often contain personally-issued credentials used for configured DB connections, etc. which (at least) the UserId is saved, if not the password.

Is there a configuration setting in either TFS or VS that would check the package and remove all credentials upon checking in?

I suspect this would be something along the lines of a check by the server when checking in, but that is more based on a guess rather than knowledge.

I have a good working knowledge of both applications, though configurations of this kind are not something I am very cognoscente of.

Thanks in anticipation

Visual Studio
Visual Studio
A family of Microsoft suites of integrated development tools for building applications for Windows, the web and mobile devices.
5,202 questions
SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,593 questions
0 comments

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Olaf Helper 45,111 Reputation points
    2024-10-02T05:07:25.33+00:00

    or VS that would check the package and remove all credentials upon checking in?

    In VS / SSIS package there is a property "ProtectionLevel".

    Set it to "DontSaveSensitive" and credentials won't be saved within the package.

    See Access Control for Sensitive Data in Packages

    1 person found this answer helpful.

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.