Hi all,
I'm working on a data migration project using Cozyroc SSIS+ 1.6 SR-3. The process involves the creation of Contacts and their activities coming from a legacy system - SQL Server Database. The package is very simple 2 Data Flow Tasks, one for Contacts using
OLDB Source and Dynamics CRM Destination and another Data Flow Task for phonecalls using the same OLDB Source and Dynamics CRM Destination.
After I tested the mappings with 100 to 500 records I proceeded to make a more realistic test and I tried to insert up to 10,000 records. That failed with the error:
[Destinatoion WRCTESTDEV [44]] Error: An error occurred with the following error message: "System.ServiceModel.Security.MessageSecurityException: An unsecured or incorrectly secured fault was received from the other party. See the inner FaultException
for the fault code and detail. ---> System.ServiceModel.FaultException: ID3242: The security token could not be authenticated or authorized.
--- End of inner exception stack trace ---
At the beginning I thought it was some plugins running on create of Contacts but I disabled them and I got the contacts created faster. Then I ran another test to create 10,000 contacts and their phonecalls - around 68,000 records - and that failed again. After
many other tests I got to the point where I can create 10,000 contacts and about 30,000 phonecalls but something I found is the Package errors out after 8 hours and 5 minutes of running.
My CRM version is 2013 with IFD.
Ricardo Barona Application Developer