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...b;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?

How about using ActiveX script job, then writing an ADO script directly using
ADSI? You would then have to manage the table inserts yourself within your
script and not use the data pump. It looks like you have the skill set
required to do this. Just do it inside of an ActiveX script.

Charles Kangai, MCT, MCDBA



"evanda (AT) gmail (DOT) com" wrote: