September 3, 2008 at 1:32 pm
I'm pretty sure I know why, but that doesn't tell me how to fix it!
The standard AD query will only return 1,000 rows, unless you set the "Page Size" parameter in the connection. Then it will return the "Page Size" number of rows, then return another "Page Size".
The problem is, I have no idea how to set the Page Size within SSIS...all the references I've found tell me how to do it in VB or C#, but I'd really prefer to do this in a data source.
Anyone run into this and know how to set the Page Size?
September 3, 2008 at 2:04 pm
That is because the PageSize is not set in SSIS.
Here is a scary solution: http://support.microsoft.com/default.aspx?scid=kb;en-us;315071&sd=tech
Personally, I prefer this one: http://codebetter.com/blogs/brendan.tompkins/archive/2003/12/19/4746.aspx
September 4, 2008 at 6:31 am
Actually, the page size is set in two places.
First, on the AD DC/GC (and that's the MS support article), you can set the default/maximum page size. The problem there is that the max that can be set is 1,000.
On the query side, however, if you don't specify a page size in your LDAP query, then AD will return only that many records (ie. only one page). It's up to the requestor (in this case SSIS) to tell LDAP that it wants multiple pages back.
I've had exactly the same problem with using SQL...works great, just won't bring back more than 1,000 rows.
May 27, 2009 at 9:47 am
I have a similar issue with AD limiting the number of rows returned. Did you ever find a resolution to this problem?
Thanks!
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply