I have created an SSIS package for migrating data from Microsoft Dynamics CRM to SQL server.The SSIS package is working fine.But some data are missing from the table in SQL server after migration.What are the known possibilities to miss the data which is available in CRM and not in SQL Server?
1条答案
按热度按时间mf98qq941#
Thank you for the comments. The mistake is, there was a service timeout parameter in SSIS package which was set to 120. But I had to load a large amount of data from crm to sql server table. Somehow the timeout error was occured.But still it showed the status as succeeded.
It was little bit confusing. The timeout had been changed to a large value which was more than 120 .Hence the problem was solved. Since I am a beginner in these kind of activities, comments here helped me to identify the mistake I have made.