SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


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


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

Author
Message
bhushan_juare
bhushan_juare
SSC-Enthusiastic
SSC-Enthusiastic (108 reputation)SSC-Enthusiastic (108 reputation)SSC-Enthusiastic (108 reputation)SSC-Enthusiastic (108 reputation)SSC-Enthusiastic (108 reputation)SSC-Enthusiastic (108 reputation)SSC-Enthusiastic (108 reputation)SSC-Enthusiastic (108 reputation)

Group: General Forum Members
Points: 108 Visits: 390
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
Lowell
Lowell
One Orange Chip
One Orange Chip (29K reputation)One Orange Chip (29K reputation)One Orange Chip (29K reputation)One Orange Chip (29K reputation)One Orange Chip (29K reputation)One Orange Chip (29K reputation)One Orange Chip (29K reputation)One Orange Chip (29K reputation)

Group: General Forum Members
Points: 29264 Visits: 39985
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
bhushan_juare
SSC-Enthusiastic
SSC-Enthusiastic (108 reputation)SSC-Enthusiastic (108 reputation)SSC-Enthusiastic (108 reputation)SSC-Enthusiastic (108 reputation)SSC-Enthusiastic (108 reputation)SSC-Enthusiastic (108 reputation)SSC-Enthusiastic (108 reputation)SSC-Enthusiastic (108 reputation)

Group: General Forum Members
Points: 108 Visits: 390
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
Lowell
One Orange Chip
One Orange Chip (29K reputation)One Orange Chip (29K reputation)One Orange Chip (29K reputation)One Orange Chip (29K reputation)One Orange Chip (29K reputation)One Orange Chip (29K reputation)One Orange Chip (29K reputation)One Orange Chip (29K reputation)

Group: General Forum Members
Points: 29264 Visits: 39985
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
bhushan_juare
SSC-Enthusiastic
SSC-Enthusiastic (108 reputation)SSC-Enthusiastic (108 reputation)SSC-Enthusiastic (108 reputation)SSC-Enthusiastic (108 reputation)SSC-Enthusiastic (108 reputation)SSC-Enthusiastic (108 reputation)SSC-Enthusiastic (108 reputation)SSC-Enthusiastic (108 reputation)

Group: General Forum Members
Points: 108 Visits: 390
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
Phil Parkin
SSCoach
SSCoach (19K reputation)SSCoach (19K reputation)SSCoach (19K reputation)SSCoach (19K reputation)SSCoach (19K reputation)SSCoach (19K reputation)SSCoach (19K reputation)SSCoach (19K reputation)

Group: General Forum Members
Points: 19426 Visits: 20462
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.


Help us to help you. For better, quicker and more-focused answers to your questions, consider following the advice in this link.

If the answer to your question can be found with a brief Google search, please perform the search yourself, rather than expecting one of the SSC members to do it for you.

Please surround any code or links you post with the appropriate IFCode formatting tags. It helps readability a lot.
CozyRoc
CozyRoc
SSCrazy
SSCrazy (2.5K reputation)SSCrazy (2.5K reputation)SSCrazy (2.5K reputation)SSCrazy (2.5K reputation)SSCrazy (2.5K reputation)SSCrazy (2.5K reputation)SSCrazy (2.5K reputation)SSCrazy (2.5K reputation)

Group: General Forum Members
Points: 2524 Visits: 2235
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
n79799
Valued Member
Valued Member (61 reputation)Valued Member (61 reputation)Valued Member (61 reputation)Valued Member (61 reputation)Valued Member (61 reputation)Valued Member (61 reputation)Valued Member (61 reputation)Valued Member (61 reputation)

Group: General Forum Members
Points: 61 Visits: 122
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.
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search