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)

Sort by

Aric Levin - MVP 30,190 Moderator on at

Like (1)

Report
Copy link

Link copied!

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
Copy link

Link copied!

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
Copy link

Link copied!

See below screenshots:

Columns:

Hope this helps.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report
Copy link

Link copied!

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
Copy link

Link copied!

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
Copy link

Link copied!

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