Post reply

email table with data through SSIS package

  • June 6, 2015 at 9:53 am

    #318053

    Hi,

    I have requirement of sending table data or result of an query as an email with SSIS package.

    Any idea where to start, I don't want complete solution, but need somthing as reference to start with!

    Thanks.

    P

  • June 7, 2015 at 11:25 am

    #1803546

    Hi,

    You shall need to send your text file as attachment using the send mail task (SMT). In the SMT:- MessageSourceType="Direct Input", Attachment=Path & filename of CSV etc. You configure the attachment as an expression and create a varibale whose path is the text file. Then added that variable to the expressions box for FileAttachments property of SMT.

    Hope this helps

  • June 8, 2015 at 7:21 am

    #1803664

    actually I have table like as follows

    SID Name Grade email

    101 Peter 87 peter@example.com

    101 Shalu 88 Shalu@example.com

    101 Parth 90 Parth@example.com

    I have to send each individual email with their Name and Grade as body of the email.

    I also have to schedule this every other day!

    do you think procedure would be better that SSIS package?

  • June 8, 2015 at 8:46 am

    #1803713

    I really enjoyed the piece, Use SSIS to send emails[/url] by Joe Millay, and have used it as a basis for my own implementation.

    The article does represent a complete solution, though you could benefit by just analyzing the Script Task that does the heavy lifting when it comes to sending the e-mail. However, since you're talking about sending individual grade emails to a group of people, I think you should consider using the author's whole system, which is built specifically for mass individualized distribution.

    Good Luck.

    - Adam

  • June 11, 2015 at 12:48 pm

    #1804808

    My requirements are little different.

    I want to send to each individual their own record. Let's say how much sales he did on that day!

  • June 11, 2015 at 1:05 pm

    #1804812

    Learner44 (6/11/2015)

    My requirements are little different.

    I want to send to each individual their own record. Let's say how much sales he did on that day!

    Yes, that's exactly the kind of use that the system in the article is for. Any quantity of individualized e-mails. It's not a 5 minute fix, but it's a high quality solution.

  • June 11, 2015 at 1:10 pm

    #1804813

    got it...working on it...but let me know if you have any other article..

    Thanks.

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

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