January 11, 2012 at 1:22 pm
Ive read online how you can set a variable as "sensitive" in SSIS so that, depending on the protection level, its data will not be stored.
I cannot figure out how to make a variable ( or any package component) sensitive.
can anyone advise how i make a variable or component sensitive?
January 11, 2012 at 2:11 pm
winston Smith (1/11/2012)
Ive read online how you can set a variable as "sensitive" in SSIS so that, depending on the protection level, its data will not be stored.I cannot figure out how to make a variable ( or any package component) sensitive.
can anyone advise how i make a variable or component sensitive?
There is no property to set a variable to "sensitive"...I think you may be misinterpreting the use of a package's protection level.
You can set the protection level of a package to "DontSaveSensitive" (package-level property). That means that any sensitive information (which is typically passwords in connection managers) will not be saved. This property has no effect on user-defined variables though.
EDIT: See the following as a reference http://msdn.microsoft.com/en-us/library/ms141747.aspx
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply