In my exacttarget when I'm importing data from salesforce report I'm getting "Casesensitive Salesforce Id" error. I'm importing data from salesforce Campaign reports which contains Lead/Contact Id column.
Salesforce Stack Exchange is a question and answer site for Salesforce administrators, implementation experts, developers and anybody in-between. It only takes a minute to sign up.Sign up to join this community
I faced the same issue recently where I got the error CaseSensitiveSalesforceID when I tried to import into Exacttarget a Salesforce report built on a custom report type that included the contact id field from a lookup.
The issue was that Exacttarget/Marketing Cloud doesn't just expect a contact id or lead id as the key it also expects the column name to be exactly Contact ID or Lead ID.
The default value in my custom report type was Primary Contact : Contact ID. I changed this to Contact ID and it worked fine.
I recently came across an article I think relates to your error for the case sensitive salesforce ID.
Do you have ContactID or LeadID set as primarykey on the import? Then I think this article will give you some tips: