[resolved] importing body of salesforce attachment

One Star

[resolved] importing body of salesforce attachment

Hi,
I am trying to import and export attachments between two different orgs.
When I extract the attachments, the default schema sets Body as type of String, but when I do the insert with the same schema I get the 'Invalid Batch' error.
I have verified and the body I get from the attachment is a base 64 string, so why is this happening?
It works even if I enter the same string in the workbench form for insert.
Any idea on how to import attachments?
Thanks

Accepted Solutions
One Star

Re: [resolved] importing body of salesforce attachment

OK, got it. I was using a tSalesforceOutputBulkExec, but a simple tSalesforceOutput solves the problem. The body String does not need to be converted to anything.

All Replies
One Star

Re: [resolved] importing body of salesforce attachment

OK, got it. I was using a tSalesforceOutputBulkExec, but a simple tSalesforceOutput solves the problem. The body String does not need to be converted to anything.