all groups > sql server dts > june 2007 >
You're in the

sql server dts

group:

OLE DB Providers available within DTS


OLE DB Providers available within DTS LittleGlenn
6/20/2007 8:49:00 AM
sql server dts: Within SQL Server 2000 , I am attempting to create a DTS Package to transfer
data from Active Directory to SQL Server. Setting up the SQL Connector is no
problem, but the list of OLE DB Providers does not include the provider for
Active Directory.

Checking the registry under

HKEY_CURRENT_USER\Software\Microsoft\Microsoft SQL
Server\80\DTS\Enumeration\OLEDBProviders

there are 12 providers listed (including OLE DB Provider for Microsoft
Directory Service). Only 3 are appearing in the 'Data Source' drop-down list
within the Connection Properties interface of DTS.

RE: OLE DB Providers available within DTS LittleGlenn
7/4/2007 2:10:00 AM
I have now produced a working solution via VB script and no longer require an
answer to this question.

[quoted text, click to view]
AddThis Social Bookmark Button