135
Hi
Could you pls let me know how to insert /update/delete Data into CRM 2013 online through ssis .As ssis donot have any CRM Connector challenge is to acheive it through script .Note: Without using any third party tools [Scribe ,kingsway..] I should achieve it.
Kindly suggest any good solution.
*This post is locked for comments
When calling a web service, I would prefer to map it manually but see below links if it helps you.
"msdn.microsoft.com/.../gg328321.aspx"
"msdn.microsoft.com/.../gg309317.aspx"
"msdn.microsoft.com/.../hh547396.aspx"
It would be great if you indicate helpful posts as verifying answers.
Thanks for the repsonse problem got resolved I have installed all .dll's in GAC using CMD
Its working fine now .
One clarification needed .using this method [calling webservice ] is their any way to map columns automatically rather than explicitly mapping each and every column for Insertion/deletion/updation
Hi,
MAke sure all the referenced dlls in your utility are upgraded to new version when you upgrade a single file. i.e. Microsoft.Xrm.sdk, ...SDK.Proxy & if required then ...SDK.Client all these should be taken from new SDK library. If you update only one of these but not other specially ...sdk.proxy, then you'll face such errors.
Hi Scott
When I used SDK webservices Iam getting "could not load file or assembly "'Microsoft.Xrm.Sdk, Version=6.0.0.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35' or one of its dependencies. The system cannot find the file specified.
I tried placing XRM .Dll in assembly folder but then same error is replicating
Kindly help me how to resolve.
You could try calling the webservices directly, code against the SDK or check out CozyRoc. Scribe is built specifically for things like this and is priced pretty well for all the work it saves you though.
You can just simply call the CRM WS and work from that...
You can connect to the SDK Webservices via SSIS (a33ik.blogspot.co.uk/.../integrating-crm-2011-using-sql.html) but really you are better off using Kingswaysoft's connector (www.kingswaysoft.com/.../ssis-integration-toolkit-for-microsoft-dynamics-crm) - the time you will save will be well worth it.
Hope this helps,
Scott
#1
Mohamed Amine Mahmoudi
83
Super User 2025 Season 1
#2
Community Member
52
#3
dkrishna
6
Share
Report
All responses (
Answers (
