Unable to use SalesForce destination component from SSIS

Discussion of open issues, suggestions and bugs regarding ADO.NET provider for Cloud Applications
Post Reply
sameer.kumar
Posts: 1
Joined: Tue 09 Jun 2015 17:54

Unable to use SalesForce destination component from SSIS

Post by sameer.kumar » Tue 09 Jun 2015 18:15

I have a SSIS data flow task containing a flat file source and SaleForce destination. When I execute the task I get the below error:
Devart Salesforce Destination] Error:
Unable to create/update fields: Office_Phone__c, MMD_Alt_State_Prov__c, LastCUUpdateDate, IsDeleted, PhotoUrl, JigsawContactId, Org_MMD_ID__c, LastCURequestDate, Org_Type__c, MailingAddress, IsEmailBounced, Name. Please check the security settings of this field and verify that it is read/write for your profile or permission set.
For pulling down the records I used your SalesForce source component and OOB flat file destination component. So no "__c" came down.
Can you help me what I'm doing wrong?

Thanks for your help!

Shalex
Site Admin
Posts: 9543
Joined: Thu 14 Aug 2008 12:44

Re: Unable to use SalesForce destination component from SSIS

Post by Shalex » Wed 10 Jun 2015 08:37

1. The names of custom objects/fields should be specified without the "__c" suffix when accessing them via dotConnect for Salesforce interface. An exception to the rule: if the object is created with the name, which already exists (e.g.: "Account"), the suffix must be used ("Account__c").
2. Have you created the corresponding columns in Salesforce (manually, via web interface)?

Post Reply