Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

SSIS Package Configurations question Expand / Collapse
Author
Message
Posted Wednesday, May 27, 2009 7:33 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Wednesday, October 14, 2009 7:33 AM
Points: 32, Visits: 29
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
Post #724074
Posted Wednesday, May 27, 2009 8:31 AM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: 2 days ago @ 11:30 AM
Points: 1,101, Visits: 933
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.
Post #724166
Posted Monday, June 1, 2009 11:39 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Wednesday, October 14, 2009 7:33 AM
Points: 32, Visits: 29
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
Post #726867
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse