Storing GUID from Active Directory thorugh Script Task(VB.Net)

Question

ObjectGUID. 
which will store the active directory GUID for the users.
but instead of values i am getting NUll for all the user

This Is My configuration

VBscript:- converting hex to string

'object GUID
                        If key = "objectGUID" Then
                            values = CType(entry.Value, ResultPropertyValueCollection)
                            Dim GuidByteAr() As Byte = values.Item(0)
                            Dim TestGuid As New Guid(GuidByteAr)
                            objectGUID = TestGuid.ToString()

Destination Database column type as nvarchar

Source Configuration

Answer 1

Hi Ranga,

How do you use the VBScript is unclear so place the DataViewer right after the component that captures the GUIDs and see if they present, I think they are not getting picked up by the code shown.

---

Arthur

MyBlog

Twitter

Answer 2

Hi Rangareddydt,

According to your description, you want to use VB script to resolve GUID to String from Active Directory in SSIS Script Component.

To achieve your requirement, we can refer to the following thread:
http://serverfault.com/questions/466594/script-to-resolve-guid-to-string-in-active-directory

Besides, please note that we can directly specify the ObjectGUID output column with unique identifier [DT_GUID] data type, then use Derived Column Transformation to convert the GUID. The following thread may help you:
https://social.msdn.microsoft.com/Forums/sqlserver/en-US/6ce5b4d2-913a-40f1-9797-105783181f5e/ssis-variable-that-should-contain-uniqueidentifier?forum=sqlintegrationservices

Thanks,
Katherine Xiong

---

Katherine Xiong
TechNet Community Support