SSIS Extract Attachments from Inbox

SSIS and Import/Export
1

Greetings,

I am using EWS to extract attachments from a general Exchange Inbox. I have give the the SQL Services account (ADirectory) When I run the SSIS package locally it does extract the attachments. But when SSIS package is deployed as part of a SQL Job, it does not fail but it does fail to extract the attachments.

I even gave the sql services account full permissions to the general Inbox. I assume this is some sort of permission/impersonation issue? Thanks

2

Ok many issues involved here

  1. Whatever user you are running the sql job as needs to have delegate permission to the Inbox you are trying to access
  2. When you point to the EWS dll in Visual Studio, whatever folder that dll is in needs to also exist in the same folder on target deployment server :rage:

Now it works !

1 Like