Migrating Email Attachment using KingswaySoft SSIS

(0) Share

Report

Posted on by Community Member

Hi, does anyone know how to migrate email attachments using this tool? I have emails copying across fine and the activityMimeAttachment entity also.

But when i got to select the target entity in the CRM destination (D365 in my case) the attachment entity it's not available in the list of target entities. Any help/pointers is appreciated.

*This post is locked for comments

I have the same question (0)

All responses (6)

Answers (2)

Aric Levin - MVP 30,190 Moderator on at

Like (1)

Report

Take a look at the following post:

www.cloudfronts.com/images-notes-attachments-migration-using-ssis-integration-toolkit-kingswaysoft

Hope this helps.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Hi Aric, I have already seen this thanks, but this is for attachments on notes for example. I'm trying to copy over attacments for emails which i believe are stored in another table.

Was this reply helpful? Yes No
Verified answer

Aric Levin - MVP 30,190 Moderator on at

Like (1)

Report

See below screenshots:

Columns:

Hope this helps.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Hi again Aric, this is for the linking entity between the email and the attachment i believe and this works fine for me. However it;s the actual attachment itself i'm having issues with how to move.

Was this reply helpful? Yes No
Suggested answer

Community Member on at

Like (1)

Report

Hi Graeme,

if you implement as Aric did, it will work. At least how I did it for an on-prem to cloud migration.

You see in the Columns screenshot the "Body" row? That's were your attachement will be saved and directly linked to your email.

Was this reply helpful? Yes No
Verified answer

Community Member on at

Like (0)

Report

Ok, so this is now working.

However, I had to modify the mapping to the following, omitting the attachment id.

As i kept getting an error advising the attachment id didn't exist, well it doesn't, as this process is creating a new one when running.

Was this reply helpful? Yes No