Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
SergioM
Posting Yak Master
170 Posts |
 Posted - 2012-10-11 : 11:21:50
|
| Some of the files that I need to process come in the form of e-mail attachments. Since I can't do it out of the box, I looked at the following solutions. But neither one is for me. Is there an alternative? How do you process e-mail attachments for SSISDownload Mail Task from Codeplexhttp://downloadmailtask.codeplex.com/A great idea, but it just doesn't work. It may work (or may once have worked) with SQL 2005, but I can't get it to work on SQL 2005 & it definitely doesn't work in 2008. Though this still might be the cheapest alternative if I outsource the workReceive Mail Task from Cozyrochttp://www.cozyroc.com/ssis/receive-mail-taskClearly the easiest solution. I only mention it so that no one else suggests it to me. The project I'm working on can't invest $2.5KMailDrop (non-SSIS)http://www.getmaildrop.com/Then I figured, maybe I would use something else & refer to the files locally. But the only free software I found has one final update which basically says it is not working. No previous versions are offered.Tips, ideas, conclusions? |
|
|
SergioM
Posting Yak Master
170 Posts |
Posted - 2012-10-11 : 12:12:10
|
| UPDATE: I am now finding a lot of good snippets of code for downloading e-mail attachments. I'll probably just go that route with a script task. Especially since I'm perfectly OK with deleting the e-mail after it's downloaded (thereby simplifying the whole process). This may not be the place to ask, but can anyone point me to a good tutorial? |
 |
|
|
|
|
|
Downloading e-mail attachments?