CRM Source FetchXML with "count" attribute errors out

[pauls...@gmail.com]

I'm trying to use the "count" attribute to limit the number of records coming into my SSIS package through the Cozyroc CRM Source component. Using SSIS+ 1.6 SR4.

CRM Source works OK with fetchxml like this:

<fetch version="1.0" output-format="xml-platform" mapping="logical" distinct="false" page="1">

  <entity name="annotation">

    <attribute name="filename" />

... 

But produces errors when the "count" attribute is added. (Fetchxml generated via user variable for count value in an expression.

<fetch version="1.0" output-format="xml-platform" mapping="logical" distinct="false" page="1" count="54">

  <entity name="annotation">

    <attribute name="filename" />

... 

Errors:

[Get Crm Notes [14]] Error: An error occurred with the following error message: "System.ServiceModel.FaultException`1[CozyRoc.Dynamics.Crm2011.OrganizationService.OrganizationServiceFault]: Invalid XML. (Fault Detail is equal to CozyRoc.Dynamics.Crm2011.OrganizationService.OrganizationServiceFault).".

[Get Crm Notes [14]] Error: Attempt to read message string for 0xc02090f5 failed with error 0xc02090f2. Make sure all message related files are registered.

[SSIS.Pipeline] Error: SSIS Error Code DTS_E_PRIMEOUTPUTFAILED.  The PrimeOutput method on Get Crm Notes returned error code 0xC02090F5.  The component returned a failure code when the pipeline engine called PrimeOutput(). The meaning of the failure code is defined by the component, but the error is fatal and the pipeline stopped executing.  There may be error messages posted before this with more information about the failure.

Is "count" attribute supported in Cozyroc CRM Source fetchxml? Do I need to do something differently?

[Ivan Peev]

You cannot use count attribute in your FetchXML statement. The count attribute is setup by the Dynamics CRM Source component and used for processing the data in batches. You have to come up with different algorithm to limit the data you want to retrieve.