April 30, 2012 at 7:55 am
I came across a dstconfig file that contained the UserID and Password for an AS400 Login.
I just created a dtsconfig for another package and it is not visible?
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
April 30, 2012 at 9:39 am
That sounds right, it won't write out a password when the config file is created, the other file must have had it entered or it was contained in a variable and not a connection manager..
CEWII
April 30, 2012 at 10:04 am
So then if you wanted to could edit the file and replace the **** with the actual pasword?
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
April 30, 2012 at 11:25 am
Yes. It isn't going give you passwords. That would be a major security breach.
CEWII
April 30, 2012 at 11:34 am
I found the passwords for two accounts in a dtsconfig file.
One is for a Windows Account and the other is for an AS400 Account.
That is some tight security.:w00t:
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
Viewing 5 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply