Does anyone have any examples of setting up a connection manager in SSIS to read information from Microsoft Active Directory I would like to retrieve a list of users and populate them into a SQL Server table.
Thanks!
Harry
Active Directory access in SSIS
Hot Topic
- How to insert a byte() to a blob column?
- How can I put a newline within a string column?
- Catastrophic failure
- Tool to Switch between 2000 and 2005
- Cannot Start SQL Server Database Services - SQL Server Express April CTP
- Event ID: 107 MSSQLSERVER cannot connect to the report server database
- SSIS will not start after SQL Server 2005 SP1 upgrade
- Management studio - extensibility?
- Retieving ODBC Settings.
- Syntax error converting the varchar value 'a' to a column of data type int
SQL Server
- Cube corruption
- Heeeeellllllllppppppppp!!!! Replication Latency in Dist Agents
- SQL Server Enterprise Manager
- how can i query the date one week back from now?
- Problems with Date And Time
- Logging blues
- Sql Server 2000 connection problem
- Wow, thanks
- 32bit Admin tools when the only media you have is 64 bit
- Configuration Manager ?
Active Directory access in SSIS
Naseer_PK
BOL has an example for a script task but it should be fairly straight forward to convert it to a script component. There is also an OLEDB driver for active directory that should be able to be used directly from the OLEDB source (although I don't know whether anyone has actually tried using it yet).
ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/dtsref9/html/a88fefbb-9ea2-4a86-b836-e71315bac68e.htm
HTH,
Matt