locked
check outlook inbox folder RRS feed

  • Question

  • Hi,

    How can ssis check for files received in the outlook inbox folder please?

    thank you

    Monday, December 7, 2015 4:40 PM

Answers

  • I found a good enough example: http://www.pixelchef.net/content/rule-autosave-attachment-outlook

    Arthur

    MyBlog


    Twitter

    • Marked as answer by arkiboys Friday, December 11, 2015 1:53 PM
    Friday, December 11, 2015 2:13 AM

All replies

  • using Script task

    like

    http://www.codeproject.com/Articles/390649/SSIS-Script-Task-Extracting-attachments-from-Outlo


    Please Mark This As Answer if it solved your issue
    Please Vote This As Helpful if it helps to solve your issue
    Visakh
    ----------------------------
    My Wiki User Page
    My MSDN Page
    My Personal Blog
    My Facebook Page

    • Proposed as answer by Katherine Xiong Wednesday, December 9, 2015 9:24 AM
    Monday, December 7, 2015 4:55 PM
  • Hi arkiboys,

    Presently SSIS has no MS Outlook integration components provided out of the box.

    Your options are:

    1) Create a custom Outlook adapter in C#/VB .Net and register for use in SSIS, or

    2) Create a proxy app that hands over the data for SSIS to process.

    I personally think it should be an Outlook side trigger (the so called RULE) that upon discovering an attachment deposits its for SSIS to process.

    I need to say SSIS (ETL in general) processing Outlook files is not an idiomatic way of its use. I just can't imagine a package running on your laptop checking Outlook emails for attachments.


    Arthur

    MyBlog


    Twitter

    • Proposed as answer by Katherine Xiong Wednesday, December 9, 2015 9:24 AM
    Monday, December 7, 2015 5:01 PM
  •  i have the same problem. thanks for that
    Monday, December 7, 2015 5:08 PM
  • i have the same problem... thanks for that
    Monday, December 7, 2015 5:09 PM
  • Hi arkiboys,

    Presently SSIS has no MS Outlook integration components provided out of the box.

    Your options are:

    1) Create a custom Outlook adapter in C#/VB .Net and register for use in SSIS, or

    2) Create a proxy app that hands over the data for SSIS to process.

    I personally think it should be an Outlook side trigger (the so called RULE) that upon discovering an attachment deposits its for SSIS to process.

    I need to say SSIS (ETL in general) processing Outlook files is not an idiomatic way of its use. I just can't imagine a package running on your laptop checking Outlook emails for attachments.


    Arthur

    MyBlog


    Twitter


    Hi,
    Do you mean to setup a rule in outlook to check a folder for emails with .xlsx and once found move a copy of that attachment to the network share?
    Thanks
    Wednesday, December 9, 2015 10:27 AM
  • Yes, Outlook should hand off the attachments for processing.

    Arthur

    MyBlog


    Twitter

    Wednesday, December 9, 2015 8:59 PM
  • Yes, Outlook should hand off the attachments for processing.

    Arthur

    MyBlog


    Twitter

    Hi,
    I do not know how to do this in outlook.
    Are you able to give me guidance please?
    Thanks
    Thursday, December 10, 2015 11:38 AM
  • I found a good enough example: http://www.pixelchef.net/content/rule-autosave-attachment-outlook

    Arthur

    MyBlog


    Twitter

    • Marked as answer by arkiboys Friday, December 11, 2015 1:53 PM
    Friday, December 11, 2015 2:13 AM
  • I found a good enough example: http://www.pixelchef.net/content/rule-autosave-attachment-outlook

    Arthur

    MyBlog


    Twitter


    Very good.
    Thank  you
    Friday, December 11, 2015 1:53 PM
  • I would recommend you check the commercial COZYROC Receive Mail Task. You can use the task to download the recent messages from your email server and extract the attachments from them.

    SSIS Tasks Components Scripts Services | http://wwww.cozyroc.com/

    Sunday, December 13, 2015 5:25 PM