I was able to pull the users from Active Directory into my sql server 2005 User table.
I followed http://blog.tech-cats.com/2007/09/querying-active-directory-through-sql.html
It successfully pulls user's generic information like givenName ,sn ,displayName, sAMAccountName,
telephoneNumber ,mobile , mail ,department, physicalDeliveryOfficeName
The company I work for is distributed globally. Each country is located as a separate folder in active directory. When I pull user's into sql server table I would like to know which folder from active directory are they coming from in order for me to group users correctly based on country