CRM Online 2015, the lead is already closed RRS feed

  • Question

  • Hi,

    I was requested to close thousands of leads in CRM according to an Excel spreadsheet, using SSIS with KingswaySoft plugin.  The data flow is quite simple.  I merge-join EmailAddress in Excel with Emailaddress1 in lead in Dynamic CRM Source, then use the resulting leadid, the unique key, to lookup lead entity in Dynamic CRM Destination, and update statecode from 0 (open) to 2 (disqualified).

    The problem was the data flow broke at the Destination.  SSIS gave the error: the lead is already closed.  Every "Execute Task" only updated the first lead in the list, then stopped with the red X. 

    Anyone has the similar experience previously?  Thanks.

    Thursday, September 24, 2015 12:02 AM