Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Get username & password?

Status
Not open for further replies.
jgoodman00

jgoodman00

Programmer
Jan 23, 2001
1,510
Is it possible to get the password of the user, so that it can be used in executing a dts package?

We have a RESULTS table, which logs a users name against records. The records are generated when users run queries. I need to export the records which are contained in the results table, belonging to the current user. I can get the user, but do not know how to get their password.

I need to get their username & password, so that these can be entered as parameters for the dts package, so that it exports the correct records.

Is there an alternative? James Goodman
 
Sort by date Sort by votes
Hi,
You need to write code using the SQL-DMO API.
Yaniv
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

Marclem
  • Locked
  • Question
Get Opinio Last Login Data
Replies
5
Views
438
Andrzejek
Andrzejek
ahmedsa2018
  • Locked
  • Question
How to get monther per part id from last date to current date and include remaining date ? 1
Replies
7
Views
455
JohnBayne
JohnBayne
ahmedsa19051985
  • Locked
  • Question
How to get FeatureName and FeatureValue separated by $ for table AllData ?
Replies
0
Views
178
ahmedsa19051985
ahmedsa19051985
Cpreston
  • Locked
  • Question
How to get rid of { fn } in my View code
Replies
5
Views
395
Andrzejek
Andrzejek
Auguy
  • Locked
  • Question
Determine sa Password When Signed On As Administrator User Thru Windows Authentication 1
Replies
2
Views
217
Auguy
Auguy

Part and Inventory Search

Sponsor

Back
Top