February 3, 2011 at 9:13 am
if i have to use login and pwd from a table how do i do it in ssis config file?
February 3, 2011 at 12:31 pm
Let me see if I got this right, you are needing to get a User/pass from a table? If thats true then you don't need a config file. You MIGHT to setup where the server for the config table is. Or do I not understand the question?
CEWII
February 15, 2011 at 10:48 am
yes that is what i want to do. i am accessing Teradata and the pwd expire every 90 days so i got to go thru few steps to get the dtsconfig file changed in production and DBA doesn't like it
i was trying to find if i can store in a table user id and pwd and i just run a update statement when the pwd is changed.
can you explain more how to do that?
February 16, 2011 at 4:35 am
the easiest option would be to setup a config database / table as opposed to using a config file
_________________________________________________________________________________SQLGeordieWeb:- Jarrin ConsultancyBlog:- www.chrisjarrintaylor.co.ukTwitter:- @SQLGeordie
February 16, 2011 at 12:36 pm
Sorry I haven't been able to respond.
A table config is very similar to the config of a file config in how it is setup in the package. Unless you are applying the config in a command line or a job, then its more messy..
One of the problems associated with config files and config tables is that the password is stored in clear text so that anyone with access to the table/file can read them. This is often handled with encryption. However in many cases service or faceless accounts do not have expiration dates set and by policy are changed every year at least.
Coming from some very hightly controlled environments a password change every 90 days is not something the DBA should be complaining about (IMO), while I wouldn't like it, 90 days isn't that often and a very simple documented process could be written up to handle it.
I hope this helps..
CEWII
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply