Loading 150k User Objects from AD

#1

What is the fastest way to load 150,000 user objects (with most of the AD
user attributes) from Active Directory into a SQL table(s) using SQL2005?
Would it be best to write a CLR stored procedure that iterates the AD user
object collection, INSERTing each record or is there some faster way with SQL
Integration Services?

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Loading 150k User Objects from AD

microsoft.public.sqlserver.dts microsoft.public.sqlserver.dts

Loading 150k User Objects from AD - 12-05-2005 , 01:18 PM