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
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