Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
ddobbertin
Yak Posting Veteran
51 Posts |
 Posted - 2011-01-25 : 16:44:34
|
| Just curious if anyone has ever had the need to modify login credentials on the fly for an ODBC Oracle connection within a DTS pacakge? I have a DTS package that runs importing some HR information...that I cannot have access to, private employee information...only HR managers can access it with their ID. The users need to be able to run the DTS package whenever they want but I need them to be able to supply an ID and password when they run it. Ideally they are looking for a web page that they can put in their ID/Password and kick off the DTS job. Just throwing this out there to see if anyone might have a direction I can look.Thanks in advance. |
|
|
|
|
|
Modify ODBC/Oracle Login on the fly