Save mail files(.msg) from Mail Server using SSIS 2005

Question

Save mail files(.msg) from Mail Server using SSIS 2005

bhushan_juare

Ten Centuries

Points: 1292
More actions
September 5, 2012 at 5:27 am

#261129

Hi Guys,
I am working on SSIS packge where I want to save mail files(.msg) coming from Mail Server along with attachment using SSIS 2005
Kindly provide links if its possible...
Thanks & Regards,
Bhushan

Viewing 8 posts - 1 through 7 (of 7 total)

You must be logged in to reply to this topic. Login to reply

Lowell SSC Guru Points: 323518 More actions · Answer 1

I've done this in code in vb.net/c#.net, where you pull messages from an SMTP server, and then you can do what you want with them: delete them off the mail server, save the messages, save the attachments, etc.

I would reckon in SSIS you'll have to put the same code in place; i don't remember seeing a component to read email directly.

you could also create some CLR methods to do the same work as well, since it's the same code.

Lowell

--help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

bhushan_juare Ten Centuries Points: 1292 More actions · Answer 2

SSIS have "Script Task Component" where scripting language used is "Microsoft Visual Basic .NET" 2005

Could you please fwd me code link so to check in SSIS package ??

Lowell SSC Guru Points: 323518 More actions · Answer 3

i googled "vb.net read pop3 mail" and got lots of hits for code examples; switch it around if you are more comfortable with C#, but the code is pretty basic.

I'm not familiar enough with SSIS to give you a copy-paste example yet that I know you could use.

Lowell

--help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

bhushan_juare Ten Centuries Points: 1292 More actions · Answer 4

I don't want SSIS code what I want is Visual basic ASP.net 2005 code where save mail files (.msg) along with attachment is handled. Rest i will do in SSIS package.. Can you help me in this...??

Phil Parkin SSC Guru Points: 246978 More actions · Answer 5

bhushan_juare (9/5/2012)
I don't want SSIS code what I want is Visual basic ASP.net 2005 code where save mail files (.msg) along with attachment is handled. Rest i will do in SSIS package.. Can you help me in this...??

This is an SSIS forum. You should look for this type of help elsewhere.

The absence of evidence is not evidence of absence.
Martin Rees

You can lead a horse to water, but a pencil must be lead.
Stan Laurel

COZYROC One Orange Chip Points: 28499 More actions · Answer 6

bhushan_juare (9/5/2012)
Hi Guys,
I am working on SSIS packge where I want to save mail files(.msg) coming from Mail Server along with attachment using SSIS 2005
Kindly provide links if its possible...
Thanks & Regards,
Bhushan

If you can use third-party solutions, check the commercial COZYROC Receive Mail Task. It allows you to download message from email server using one of these protocols: IMAP, Exchange and POP3 and also extract the attachments from the message. No programming skills are required.

---
SSIS Tasks Components Scripts Services | http://www.cozyroc.com/

n79799 SSC Eights! Points: 804 More actions · Answer 7

If you have the .msg already somewhere and want to save it else......should be simple in ssis using FST.

But , lets say, if you want to extract .msg from outlook server, yes, then you will have to write code in a script task and then save the file manually in your script task.