RE: Passwords again

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

Hi Jason,

Thank you for your post.

From your description, my understanding of this issue is: You are
developing a SSIS package and you use the ODBC connection to connect to a
database. You can not see the password after you set the package protection
level to DontSaveSensitive. If I misunderstood your concern, please feel
free to let me know.

According to the SQL Books Online, when you use the Do not save sensitive
(DontSaveSensitive) protection level, sensitive information in the package
is not saved.

For all values, sensitive information is defined as:

1. The password part of a connection string. However, if you choose an
option that encrypts everything, the whole connection string will be
considered sensitive.

2. The task-generated XML nodes that are tagged as sensitive. The tagging
of XML nodes is controlled by Integration Services and cannot by changed by
users.

3. Any variable is marked as sensitive. The marking of variables is
controlled by Integration Services.

To see your password, please change the protection level to
EncryptAllWithPassword or other options.

Here is the article about the protection level:

Setting the Protection Level of Packages
http://msdn2.microsoft.com/en-us/library/ms141747.aspx

Hope this will be helpful!

Sincerely,

Wei Lu
Microsoft Online Community Support

==================================================

When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.

==================================================
This posting is provided "AS IS" with no warranties, and confers no rights.

.

Relevant Pages

  • RE: Passwords again
    ... from the package. ... My problem is that I am using a configuration file to try and populate the ... The password part of a connection string. ... please change the protection level to ...
    (microsoft.public.sqlserver.dts)
  • Re: belkin power conditioner for my Samsung LCD - is it worth it???
    ... But to make that connection direct (from lightning's ... | perspective) means that wire must be short, ... similar protection on electrical power wires). ... | inside appliances routinely makes those surges irrelevant. ...
    (alt.tv.tech.hdtv)
  • MT nightmare
    ... Everything in our house has whatever protection it can have from UPS to ... whatever has been recommended for protection we have done. ... I did not have an internet connection and the phones were all dead. ... Modem apparently fried. ...
    (sci.med.transcription)
  • Re: MT nightmare
    ... > Everything in our house has whatever protection it can have from UPS to ... I did not have an internet connection and the phones were all dead. ... Modem apparently fried. ... > connection from pole to house. ...
    (sci.med.transcription)
  • Re: Linksys router + switch vs router/switch combo
    ... Excellent information on surges and surge protection is in an IEEE ... The IEEE guide is aimed at those with some technical background. ... connection to earth, where is the earthing connection on that Belkin? ... Thus in his view plug-in suppressors ...
    (comp.sys.mac.hardware.misc)