All Forums -> Forum: Dynamics CRM Adapter for Insight -> Topic: Create Activities in CRM 2011
Forum Topic: "Create Activities in CRM 2011"

I'm trying to set up a DTS to pull activities/actions from my SQL Server database in to a CRM 2011 database. When I setup the DTS to update/insert the activitypointer, I get the following error anytime I try to create a record: "CreateEntity failed: The 'Create' method does not support entities of type 'activitypointer'."

What am I missing? Are you not able to insert activity records into CRM?



Posted by Dave M on Mar 14, 2011 10:34AM Return to top

Hi Dave,

I am just guessing here but I think on  the acitivtytypecode you are referencing the activity type code and not the activity type code of the entity in which you want to attach the activity to. I am currently doing a CRM 4 (on-prem) to CRM 2011 (online) migration and very familiar with these. I would be happy to discuss this more with you if you need additional assistance. You could also send me screenshots of your test window and I would be happy to verify what data you are trying to pass and what might look incorrect to me.

Bill Kaik, SCRIBE MVP, C5 Insight, <font></font>, 603-505-7958

Posted by Bill Kaik ( . Power User on Mar 15, 2011 10:42AM Return to top

Thanks Bill!

It turns out that you can't directly insert data into the "activitypointer" view.

It looks like you actually need to use the views that are specific to your activity type, for example, fax, phone, email, etc.

I'm using the "fax" view now to insert my fax records into CRM 2011, and it seems to be working fine.



Posted by Dave M on Mar 15, 2011 12:13PM Return to top

Hi Dave,

Yes it does get a little clugy when you use the acitvity pointer to insert different types. It can be done but you need to know what fields are valid for what type of activity. You are correct though the best way to get around that is to actually just use the specific activity entity you want to migrate (i.e fax). Hope everything else is going well with it though.

Bill Kaik, SCRIBE MVP, C5 Insight,, 603-505-7958

Posted by Bill Kaik ( . Power User on Mar 17, 2011 11:06AM Return to top
Back to Topics