active directory update

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.   

Answer 1

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

Answer 2

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

Answer 3

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.

Answer 4

VB.Net can be used in a Script Task. Besides, c# code can be converted to VB.net online (just search).

---

Arthur

MyBlog

Twitter