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

What do you mean by Tab ? Is it sheets ? Could you please provide some sample data.

Ha ha - of course you're right, Ivan. SMTP = send. That's an abstracted .Net dev worldview for you... Talk to me now on

Follow How to: Loop through Excel Files and Tables by Using a Foreach Loop Container. You can then use a Derived Column component inside the Data Flow to add a column containing the value of the string variable you created for use inside the Foreach Loop container. Talk to me now on

Hi All, In the excel file I have several diff tabs with each tab refers to each state, which I need to load all tabs into a single table. While populating the data into the SQL Server the table has a State Field which it shud automatically pick from the tab title and put it in the state field. How can I get this using SSIS. Thanks Pradeep

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 Pradeep Pradeep Pradeep, The advise Todd gave you is incorrect (Sorry Todd). The SMTP protocol can only be used for sending emails, not retrieving. The protocols used for email retrieve are POP3 and IMAP. The standard SSIS framework doesn't contain any tasks for this. If you can use third-party solutions, check the commercial CozyRoc Receive Mail Task . It supports both POP3 and IMAP and you can use it download all attachments for specific email. It also supports S/MIME decryption, in case you need to download encrypted emails.SSIS Tasks Components Scripts Services | http://www.cozyroc.com/