To get Package Execution User into Script task.
Hi All,
Currently i am working on script task and for a typical requirement, I need the User id who is executing the package.
I tried to use the WindowsIdentity.GetCurrent().Name;
but the above function return the ID of the Computer Login and not the User if from which the package has been executed.
What I want is the User executing the package and not the system login.
Appreciate any suggestions.. Thanks !!
Warm Regards,
Swapnil Kothari
February 17th, 2012 8:50am
You can get the value from a System variable called "UserName -
The account of the user who started the package. The user name is qualified by the domain name."
More info:
http://msdn.microsoft.com/en-us/library/ms141788.aspxPlease mark the post as answered if it answers your question | My SSIS Blog:
http://microsoft-ssis.blogspot.com
Free Windows Admin Tool Kit Click here and download it now
February 17th, 2012 9:26am
Are looking for the Display Name of the login user from the Active Directory of a Window environment?
If this is case, you will have to add some functionality in your package to query the active directory (using WMI)
to get a list of user logins with display names. Chaos, Disorder and Panic ... my work is done here!
February 17th, 2012 11:03am