SQLTeam.com | Weblogs | Forums

SSIS Package to import data from email attachment to excel file and add received date against the data


#1

Hi,

I have got 100 plus email in a folder and all of them have got and attachments.
I want to create a package which will copy the data from all attachments in one excel sheet and also add a column which will have the received dates of those emails against the data.The prefix of mail and attachment are same.