locked
active directory update RRS feed

  • Question

  • We are wanting to add a step to a SSIS package to delete specific entries from active directory.     Has anyone done anything like this in SSIS?    Will it have to be a script task?    Any guidance is appreciated.   
    Wednesday, April 20, 2016 12:48 PM

Answers

All replies

  • A good place to start is http://social.technet.microsoft.com/wiki/contents/articles/1293.processing-active-directory-information-in-ssis.aspx

    Deleting from AD I have never heard of.


    Arthur

    MyBlog


    Twitter

    Wednesday, April 20, 2016 2:30 PM
  • Hi sqlguy10,

    In a script task, you can use the power of C# to manage your active directory.

    Check Howto: (Almost) Everything In Active Directory via C#



    Eric Zhang
    TechNet Community Support

    • Proposed as answer by Eric__Zhang Saturday, April 30, 2016 7:15 AM
    • Marked as answer by Eric__Zhang Tuesday, May 3, 2016 8:53 AM
    Thursday, April 21, 2016 6:38 AM
  • How about visual basic? If we go the script task route, our management is going to want us to use visual basic. I was hoping to avoid the script task since my vb isn't too strong, but we may have to go that route.
    Thursday, April 21, 2016 12:56 PM
  • VB.Net can be used in a Script Task. Besides, c# code can be converted to VB.net online (just search).

    Arthur

    MyBlog


    Twitter

    • Proposed as answer by Eric__Zhang Saturday, April 30, 2016 7:15 AM
    • Marked as answer by Eric__Zhang Tuesday, May 3, 2016 8:53 AM
    Thursday, April 21, 2016 12:58 PM