1. The Ldap Source component relies on several assemblies (see screenshot below), which are installed as part of Client Tools SDK. If these DLLs are not present on your system, run SQL setup and add this component.

The screenshot is taken from SQL Server 2012 hence the 110 folder, on SQL 2008R2 the DLLs would be found in the 100 folder.

clip_image001

clip_image002

2. Download the version appropriate for your version of SQL server from the http://adssis.codeplex.com/releases

3. Run setup. If you changed the default location of SQL server installation, use the change button to navigate to the location of the PipelineComponents folder on your server. 

clip_image003

4. Add Ldap Source Component to the SSIS Toolbox

On SQL 2012

Start SQL Server Data Tools.

Create new Integration Services Project

Switch to the Data Flow Tab

Right-click anywhere on the toolbar and select Refresh Toolbox

clip_image004

LDAP Source component should now be present in the Common Section

clip_image005

Optionally, right-click on the LDAP Source component and select move to Other Sources

On SQLR2

Start SQL Server Business Intelligence Development Studio

Go to Tools and select Choose Toolbox Items…

Switch to the SSIS Data Flow Items

Set checkbox against the LDAP Source component

clip_image006

If you start new or open existing Integration Services Project, LDAP Source component should now appear under Data Flow Sources

clip_image007

Important note on integrating LDAP Source component into new or existing projects

Since LDAP Source component relies on certain SQL DLLs, which were explicitly compiled for x86, the component itself is also compiled for x86. For this reason you need to change the Run64BitRuntime property of your projects to False.

clip_image008

Failure to do so will result in the project failure at runtime.

clip_image009

Last edited Feb 27, 2013 at 8:40 PM by atcherni, version 4

Comments

No comments yet.