Can anybody tell me how to specify the DTS connection properties if I need
to connect to an LDAP database/server?

Thanks for any help.

Mary

Why not set up a linked server first so you can use that.

EXEC sp_addlinkedserver 'ADSI',
'Active Directory Services 2.5',
'ADSDSOObject',
'adsdatasource'


You can then issue queries against that.

http://msdn.microsoft.com/library/de...qd_12_94fn.asp

--

Allan Mitchell (Microsoft SQL Server MVP)
MCSE,MCDBA
www.SQLDTS.com
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org


"Mary" <mary.powers (AT) pnl (DOT) gov> wrote