Post reply

How do I query Active Directory (ADSI) using LDAP inside Script Component SSIS?

  • March 16, 2010 at 1:30 pm

    #137895

    Just when I thought I had gotten away from vbscripts and moved on to better technology someone changed the Maxpagesize setting in AD back to 1000 rows. So now my openquery from ADSI as linked server is useless. I wish to continue to use SSIS to query AD but can't find a good example of how to connect to AD in a script component. Any clues would be helpful.

    Thanks!

  • March 18, 2010 at 2:55 pm

    #1136326

    Jay Gamblin (3/16/2010)

    Just when I thought I had gotten away from vbscripts and moved on to better technology someone changed the Maxpagesize setting in AD back to 1000 rows. So now my openquery from ADSI as linked server is useless. I wish to continue to use SSIS to query AD but can't find a good example of how to connect to AD in a script component. Any clues would be helpful.

    Thanks!

    Have you tried to get your data using ADO.NET Source component?

    ---
    SSIS Tasks Components Scripts Services | http://www.cozyroc.com/

  • March 18, 2010 at 3:10 pm

    #1136338

    CozyRoc (3/18/2010)

    Have you tried to get your data using ADO.NET Source component?

    I have not. Do you have an example of connecting to ADSI with ADO.NET?

  • March 18, 2010 at 3:23 pm

    #1136344

    Jay Gamblin (3/18/2010)

    CozyRoc (3/18/2010)

    Have you tried to get your data using ADO.NET Source component?

    I have not. Do you have an example of connecting to ADSI with ADO.NET?

    I don't have. But it shouldn't be too hard to set it up.

    ---
    SSIS Tasks Components Scripts Services | http://www.cozyroc.com/

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply