Post reply

Windows Logon

  • February 12, 2009 at 9:00 am

    #126378

    I want to store windows logon in a variable in SSIS? Any ideas?

  • February 12, 2009 at 9:03 am

    #942948

    Not sure what you mean. Do you mean store a specific login, or do you mean store the login that's running the package, or something else?

    - Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
    Property of The Thread

    "Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon

  • February 12, 2009 at 9:04 am

    #942952

    I want to capture who is running the package in the variable.

    Thanks

  • February 12, 2009 at 3:32 pm

    #943241

    I don't think any system variables will hold this info.

    I believe you can capture the current user name in a Script Task (sample code shown below) and store it in a variable:

    Dim userName as String = System.Security.Principal.WindowsIdentity.GetCurrent().Name

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply