question

SivaMani-9172 avatar image
0 Votes"
SivaMani-9172 asked ZoeHui-MSFT answered

Download email content and attachments with SSIS

Dear Experts,

I have been searching for the best way to download email(Outlook 365) content/attachments with SSIS. Please help.

My requirement is, Search for a specific email (from, subject and filename) and download the attachment or the email content to a location. What is the best way to do this in SSIS?

dotnet-csharpsql-server-integration-services
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

1 Answer

ZoeHui-MSFT avatar image
0 Votes"
ZoeHui-MSFT answered

Hi @SivaMani-9172,

You could use TF component to meet the requirement.

Please carefully refer:

https://mitchellsql.wordpress.com/2015/01/11/download-emails-and-email-attachments-in-ssis/

Another way is to write .NET code in script task in which case you don't need any additional components

http://sqlandbilearning.blogspot.ae/2014/07/download-email-attachment-using-ssis.html

Regards,

Zoe


If the answer is helpful, please click "Accept Answer" and upvote it.

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.
Hot issues October

5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.