Skip to main content

Notifications

Announcements

No record found.

Community site session details

Community site session details

Session Id :
Microsoft Dynamics CRM (Archived)

Migrating Email Attachment using KingswaySoft SSIS

(0) ShareShare
ReportReport
Posted on by

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

  • Verified answer
    Community Member Profile Picture
    on at
    RE: Migrating Email Attachment using KingswaySoft SSIS

    Ok, so this is now working.

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

    7674.SSIS.JPG

    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.

  • Suggested answer
    Community Member Profile Picture
    on at
    RE: Migrating Email Attachment using KingswaySoft SSIS

    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.

  • Community Member Profile Picture
    on at
    RE: Migrating Email Attachment using KingswaySoft SSIS

    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.

  • Verified answer
    Aric Levin - MVP Profile Picture
    30,188 Moderator on at
    RE: Migrating Email Attachment using KingswaySoft SSIS

    See below screenshots:

    ssis_5F00_activitymimeattachment2.png

    Columns:

    ssis_5F00_activitymimeattachment2.png

    Hope this helps.

  • Community Member Profile Picture
    on at
    RE: Migrating Email Attachment using KingswaySoft SSIS

    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.

  • Aric Levin - MVP Profile Picture
    30,188 Moderator on at
    RE: Migrating Email Attachment using KingswaySoft SSIS

    Take a look at the following post:

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

    Hope this helps.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

🌸 Community Spring Festival 2025 Challenge Winners! 🌸

Congratulations to all our community participants!

Adis Hodzic – Community Spotlight

We are honored to recognize Adis Hodzic as our May 2025 Community…

Kudos to the April Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard > Microsoft Dynamics CRM (Archived)

#1
Mohamed Amine Mahmoudi Profile Picture

Mohamed Amine Mahmoudi 83 Super User 2025 Season 1

#2
Community Member Profile Picture

Community Member 52

#3
dkrishna Profile Picture

dkrishna 6

Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans