SSIS Package Configurations question

  • Hi

    I would like to save the properties for my SSIS packages in the SQL server database. The main reason is that I have some file references set as properties for individual components in my SSIS packages, and when moving my project from one machine to another, I dont want to change settings in the package, instead just change some properties in a configuration table in SQL server. I started to look into the functionality present for saving the SSIS data as a "Package Configuration".....this seems to be working, if I change a setting for a property in the database table created for the configuration, this will be reflected during the execution of the SSIS package...BUT, from what I thought, the settings (properties) I choose to have included in the package configuration can still be seen in the .dtsx file....Really why I'm doing this in the first place is to be able to hide file references in my .dtsx file......I thought the .dtsx file should only have some sort of cryptic reference in that text file for the properties being read from the configuration table in the database.....doesnt seem to be the case...

    Have anyone any suggestion how to "hide" file references or other properties (like usernames etc) from the .dtsx file if someone opens this file.

    Help appreciated 🙂

    Best Regards

    Helmut NIelsen

  • You can change the protection level on the dtsx package to Encrypt Sensitive Data with User Key but then you are on the only that open and maintain the package.

  • Hi could you (or someone else) please explain how to do that. Let's say I want to hidea specific property in one of my SSIS package components, for example a file path. How can I make sure this one is encrypted in my .dtsx file ?

    can someone please give some examples that takes me in the right direction....

    br

    Helmut

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply