Helen Williams
asked on
not enough Knowledge of scripts
Requirement:
1. I need to automate the download of certain types of attachments from Outlook email and import to a SQL database
a. Connecting to the outlook mailbox / inbox
b. Filter for specific Subjects / Senders
c. Determine whether emails unread
d. Download EXCEL and XML attachments
e. Save to a folder
f. Import / Append to appropriate tables in SQL database
g. Cannot use exchange API, but must connect to Outlook
2. it must be accomplished inside of an SSIS package, i understand the options are a VB or C# script, or a Powershell script
My SSIS experience is good but my scripting knowledge is very rudimentary and I can do very simple scripts. Help and guidance to accomplish this will be appreciated
1. I need to automate the download of certain types of attachments from Outlook email and import to a SQL database
a. Connecting to the outlook mailbox / inbox
b. Filter for specific Subjects / Senders
c. Determine whether emails unread
d. Download EXCEL and XML attachments
e. Save to a folder
f. Import / Append to appropriate tables in SQL database
g. Cannot use exchange API, but must connect to Outlook
2. it must be accomplished inside of an SSIS package, i understand the options are a VB or C# script, or a Powershell script
My SSIS experience is good but my scripting knowledge is very rudimentary and I can do very simple scripts. Help and guidance to accomplish this will be appreciated
ASKER
Hi
I understand that it is complex. I do not need to hire someone for the entire project and quite happy to hire someone for the script, but then I will never learn.
As to Exchange, the client wants to use Outlook. From what i see, the process differs and an installation of the EWS.api is needed, which they would like to avoid.
I understand that it is complex. I do not need to hire someone for the entire project and quite happy to hire someone for the script, but then I will never learn.
As to Exchange, the client wants to use Outlook. From what i see, the process differs and an installation of the EWS.api is needed, which they would like to avoid.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
You should hire somebody to implement the mail downloader script in SSIS.
Can you please specify why you cannot use exchange API?