"evanda@gmail.com" wrote:

> Is there a way for DTS to use a directory server as a data source? The
> only use i've seen for the directory services OLEDB provider,
> ADsDSOObject, is in the typical workaround suggestion using a
> query/view thusly:
>
> EXEC sp_addlinkedserver 'ADSI', 'Active Directory Service Interfaces',
> 'ADsDSOObject', 'adsdatasource'
> EXEC sp_addlinkedsrvlogin 'ADSI', 'false', NULL, NULL, NULL
> CREATE VIEW OpenldapOrgView AS SELECT displayName as [Name]
> FROM openquery(ADSI,
> '<LDAP://ldap.openldap.org/OU=people,DC=openldap,DC=org>;(objectClass=person);displayName;subtree')
>
> This is well and good so long as you don't need any multi-valued
> attributes, and so long as you don't need a lot of records (e.g. more
> than the 1000 active directory allows per request). (see the
> 'Limitations' section in
> http://support.microsoft.com/default.aspx?scid=kb;en-us;299410 )
>
> However, I am dealing with a lot of records, and more importantly, i
> need to somehow get the multivalued attributes. I don't mind
> transforming the data once fetched from a directory server so that it
> is meaningful to a relational db, but i need to get at that data, so i
> ask again:
>
> is there any way for DTS to get data from a directory server?
>