Using the ADO to querying the Active Directtory will get a variant to object for Integer8 Attributes.
This one show how to use the ADO.NET connection manager to retrieve data from Active Directory. The problem is the SSIS don’t support all ADO properties. There is no way to set the number of returning objects, LDAP_OPT_SIZELIMIT . In most case, the AD will return 1000.
This one show how to use the VBscript and ADO to retrieve the data from Active Directory. It use the Page Size property to get around the problem. It work well.
This one show how to use the C#.Net script and the System.DirectoryServices to retrieve data from Active Directory. It works.