our HR system has an SQL backend we'd like to take the new employee data from this database and export into Active directory for the automatic creation and deletion of Network User accounts how doable is this please and has anyone done similar?

Hello, Please check this link http://social.msdn.microsoft.com/Forums/en/sqlintegrationservices/thread/c26f1ce5-4226-4020-a3bc-60739724f92e http://www.sqlservercentral.com/Forums/Topic294547-148-1.aspx#bm996333 You will have to use script task for this , you can use c# or VB to code. thanks http://sqlage.blogspot.com/

It is doable. There are 3 ways how you can manipulate on data using SSIS interfacing the AD. In essence it is a connection that populates/consumes an object type of a variable I will point you out to a blog post to gain more detailed information: Processing Active Directory Information in SSIS http://social.technet.microsoft.com/wiki/contents/articles/processing-active-directory-information-in-ssis.aspxArthur My Blog

thanks guys with little to no sql admin or VB scripting experience, what would you recommend as training for me to be able to carry this out?

Just follow that blog post to me this is the minimum. I do not know what your strong points are. Also this post is good to give you the insight: http://www.mssqltips.com/tip.asp?tip=1657Arthur My Blog

will do thank you does this method extract the required data straight from the HR database and transfer directly into AD? or does the required data need to be extracted from the HR database and put somewhere else in order then to be processed via SSIS and transferred to AD?

The last post is how to extract the data from AD, the previous one is how to load. I gave you both just in case you need some other activities down the road. I just do not know your scenario, but typically I get the data FROM AD and then sync on the database side, but your case is different. I say so because the employee management is normally done on the AD side (e.g. add/remove a person).Arthur My Blog

Here are examples on querying AD from within SQL Server: http://www.databasejournal.com/features/mssql/article.php/3849891/Query-Active-Directory-Data-from-SQL-Server-using-T-SQL.htm you can wrap them into Execute SQL taskArthur My Blog

great i'm sure my solution is there within thanks for your time