Notifications
Announcements
No record found.
Hi All,
Can anyone point me to a document or posting that provides details on using SSIS to import data into CRM 2011?
Thanks,
Russell
*This post is locked for comments
Russell,
Are you talking about importing data directly into the CRM database?
If so, you will not find any documentation from Microsoft as this is unsupported.
There's an adaptor from CozyRoc allows you to connect SSIS to CRM via the API.
Hey Gus,
Not directly but through the API using SSIS packages.
Try the following links :
zappysys.com/.../http-post-in-ssis-send-data-to-web-api-url-json-xml
zappysys.com/.../loading-data-from-rest-api-to-sql-server-in-ssis
Hope it Helps
There are couple of ways to do
1. By 3rd party tools like Scribe or Kingswaysoft (Fast data migration & Can be Scheduled as well) - Paid
2. Create your own SSIS package to move data entity by entity( Bit tedious & time Consuming) - Free
Reference:
Scribe: www.scribesoft.com/.../data-migration
KingsWaySoft: www.kingswaysoft.com/.../microsoft-dynamics-integration
hope this helps
I would try using SSIS with Kingswaysoft CRM Connector.
It is very easy to use and supports many data source.
Unless you need to create a package and have it stored on your SQL Server, the product is free of charge when being run within Visual Studio or SSDT.
Their site has examples on how to use that and integrate it with CRM.
Hope this helps.
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
As AI tools become more common, we’re introducing a Responsible AI Use…
We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…
These are the community rock stars!
Stay up to date on forum activity by subscribing.
SA-08121319-0 4
Calum MacFarlane 4
Alex Fun Wei Jie 2
