SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


SSIS Package Configurations question


SSIS Package Configurations question

Author
Message
Helmut Nielsen
Helmut Nielsen
SSC Veteran
SSC Veteran (234 reputation)SSC Veteran (234 reputation)SSC Veteran (234 reputation)SSC Veteran (234 reputation)SSC Veteran (234 reputation)SSC Veteran (234 reputation)SSC Veteran (234 reputation)SSC Veteran (234 reputation)

Group: General Forum Members
Points: 234 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
Justin Lezon
Justin Lezon
Ten Centuries
Ten Centuries (1.3K reputation)Ten Centuries (1.3K reputation)Ten Centuries (1.3K reputation)Ten Centuries (1.3K reputation)Ten Centuries (1.3K reputation)Ten Centuries (1.3K reputation)Ten Centuries (1.3K reputation)Ten Centuries (1.3K reputation)

Group: General Forum Members
Points: 1341 Visits: 959
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.
Helmut Nielsen
Helmut Nielsen
SSC Veteran
SSC Veteran (234 reputation)SSC Veteran (234 reputation)SSC Veteran (234 reputation)SSC Veteran (234 reputation)SSC Veteran (234 reputation)SSC Veteran (234 reputation)SSC Veteran (234 reputation)SSC Veteran (234 reputation)

Group: General Forum Members
Points: 234 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
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search