Importing data from Active Directory into SQL Server Table

• jman76

  Hall of Fame

  Points: 3388

  More actions

  October 4, 2013 at 3:36 am

  #283450

  Hello

  I am having a little trouble in importing data from Active directory into SQL Server table. I have been using the following tutorial to do so: http://dataqueen.unlimitedviz.com/tag/ado-net/

  So far i have created a package with a ADO NET source with the following SQL Command: Select displayname FROM 'LDAP://Ourserver' Where Objectclass = 'User'

  When i have gone to preview the query in the ADO NET Source editor i get the message: Warning. The data type 'system.object' found on column displayname is not supported for the ADO.NET Source. This column will be converted to DT_NTEXT.

  The DisplayName field in my SQL Server table is a Varchar(50)

  After the warning i click ok. However my ADO Net Source task has a warning sign that appears next to it.

  The message next to the ADO Net Source states: The data type system object found on column displayname is not supported for ADO NET.

  I have used a Data Conversion task to convert data type DT_NTEXT to unicode string [DT_WSTR]

  My Destination source is a OLE DB Destination. I also get a red cross next to my OLE Destation stating:

  Columns DisName and DisplayName cannot convert between unicode and non-code string data types.

  In our active directory folders we have various OU folders:

  I would like to create multiple tasks to be able to import different OUs. Each OU is based on a certain depot.

  e.g OU=Birmingham

  e.g OU=Manchester

  I attempted to create a LDAP query as follows but i don't think the syntax is correct.

  Select displayname FROM 'LDAP://Ourserver OU=Manchester' Where Objectclass = 'User'

  Please could you direct me in getting the package to work.

  Regards

• jman76

  Hall of Fame

  Points: 3388

  More actions

  October 6, 2013 at 3:00 pm

  #1656195

  Any ideas anyone?

• LutzM

  SSC Guru

  Points: 107049

  More actions

  October 6, 2013 at 3:23 pm

  #1656197

  It might be an issue between Unicode an Non-Unicode data format.

  Did you try to change the data type in your target table to NVARCHAR(50)?

  (Just a pot shot though...)

  ---

  
  Lutz
  A pessimist is an optimist with experience.

  How to get fast answers to your question[/url]
  How to post performance related questions[/url]
  Links for Tally Table [/url] , Cross Tabs [/url] and Dynamic Cross Tabs [/url], Delimited Split Function[/url]

• jman76

  Hall of Fame

  Points: 3388

  More actions

  October 7, 2013 at 4:56 am

  #1656286

  Thanks for the reply. I have changed my datatype to Nvarchar (50) I am still getting the warning sign on the ADO NET task: The data type system.object found on column "displayname" is not supported for ADO NET Source. This column will be converted to DT_NTEXT.