Insert Data into CRM 2013 online through ssis

(0) Share

Report

Posted on by Gree

135

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

I have the same question (0)

All responses (7)

Answers (2)

Verified answer

ScottDurow 21 on at

Like (0)

Report

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

Was this reply helpful? Yes No
tiagolvsantos 740 on at

Like (0)

Report

You can just simply call the CRM WS and work from that...

Was this reply helpful? Yes No
Josh Thompson 1,115 on at

Like (0)

Report

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.

Was this reply helpful? Yes No
Gree 135 on at

Like (0)

Report

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.

Was this reply helpful? Yes No
Suggested answer

Rugved Gokhale on at

Like (0)

Report

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.

Was this reply helpful? Yes No
Gree 135 on at

Like (0)

Report

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

Was this reply helpful? Yes No
Verified answer

Rugved Gokhale on at

Like (0)

Report

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.

Was this reply helpful? Yes No