Can we download the excel file automatically from email and populate the data into SQL Server using SSIS.( we will get the excel files once a week) If we can do so, what are the transformations we need to use and how much VB Scripting does it include? Thank you PradeepPradeep

Thank you very much Todd for the prompt response, I will definitely go through the third-party tasks you have provided.Pradeep

You would need to use Script to retrieve emails using SMTP and extract the attachments (save them to disk). After that, a standard Foreach Loop over a File Enumerator would allow you to process those retrieved files. You could use third-party tasks to retrieve the emails and attachments - look in this directory of objects for that. Talk to me now on