Table 1 has a list of user names from a document. Table 2 is an OLEDB connection to LDAP. I'm looking to pull LDAP data based on a matching where statement for all users in table 1.
Example:
Users: LOAD [User ID] FROM UserList.xlsx (ooxml, embedded labels);
OLEDB CONNECT TO [Provider=ADsDSOObject;Encrypt Password=False;Integrated Security=SSPI;Mode=Read;Bind Flags=0;ADSI Flag=-2147483648;FetchSize=100000];
HierarchyDB: SQL SELECT cn, displayname, l, c FROM 'LDAP' Where cn=[User ID];
I suspect I'd have to use some type of "For Each" statement but nothing seems to be working. Preferably for distinct items in User ID to avoid duplication of data.
