I am beginner for SSIS, My manager wants me to create SSIS Package that can read the data from the Email attachment which is in the format of excel file and insert the same data into SQL database into warehouse. Can you able to tell me first if it is possible?? and if yes then how can I able to make it possible?? Details about my system:
SQL Server 2016, Email:- Outlook , Data Tools 2015
OK now I get it. Your question is actually more about .NET coding to Outlook. You'll need to write a script component to read from Outlook since that's not a standard component. Assuming you know C# or VB.net, it's not that hard though it will take a few days to code up and debug.