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

  • 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

  • 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!

  • 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 ??

  • 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!

  • 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...??

  • 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.


  • 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/

  • 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.

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

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