Hi,
****** id="cke_pastebin" style="position: absolute; top: 0px; width: 1px; height: 1px; overflow: hidden; left: -1000px;">
<tbody style="margin: 0px; padding: 0px; border: 0px; font-style: inherit; font-variant: inherit; font-weight: inherit; font-stretch: inherit; font-size: inherit; line-height: inherit; font-family: inherit; vertical-align: baseline;">
[TD="class: votecell"]
[TD="class: postcell"] I have got 100 plus email in a folder and all of them have got an attachment. I want to create a package which will copy the data from all email attachments in one excel sheet and also add a column which will have the received dates of those emails against the data.Can any one guide me how to do it with help of ssis package.
[/TD]
</tbody></body>I have got 100 plus email in a folder.I want to create a macro that will copy all the body details of email in an excel sheet and also add a column which will have the received dates of those emails against the data in each row.[FONT=Arial, Helvetica Neue, Helvetica, sans-serif]Can any one guide me how to do it.[/FONT]
****** id="cke_pastebin" style="position: absolute; top: 0px; width: 1px; height: 1px; overflow: hidden; left: -1000px;">
<tbody style="margin: 0px; padding: 0px; border: 0px; font-style: inherit; font-variant: inherit; font-weight: inherit; font-stretch: inherit; font-size: inherit; line-height: inherit; font-family: inherit; vertical-align: baseline;">
[TD="class: votecell"]
0down votefavorite
[/TD]
[TD="class: postcell"] I have got 100 plus email in a folder and all of them have got an attachment. I want to create a package which will copy the data from all email attachments in one excel sheet and also add a column which will have the received dates of those emails against the data.Can any one guide me how to do it with help of ssis package.
[/TD]
</tbody>