check outlook inbox folder

All replies

• 

  

  0

  Sign in to vote

  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
• 

  

  0

  Sign in to vote

  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
• 

  

  0

  Sign in to vote

   i have the same problem. thanks for that

  Monday, December 7, 2015 5:08 PM
• 

  

  0

  Sign in to vote

  i have the same problem... thanks for that
  

  Monday, December 7, 2015 5:09 PM
• 

  

  0

  Sign in to vote

  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
• 

  

  0

  Sign in to vote

  Yes, Outlook should hand off the attachments for processing.

  ---

  Arthur
  
  MyBlog
  
  Twitter

  Wednesday, December 9, 2015 8:59 PM
• 

  

  0

  Sign in to vote

  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
• 

  

  0

  Sign in to vote

  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
• 

  

  0

  Sign in to vote

  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
• 

  

  0

  Sign in to vote

  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