Post reply

Master SSIS holding all SendMail info

  • March 25, 2009 at 4:54 am

    #965885

    I'm assuming you'd just create a 1 column, 1 row table with the name of the mail server.

    Not sure what you mean here, Iv only so far tested the XML idea.

    I think i prefer your second idea:

    The other idea I've used is to have a parameter table with 2 columns (parameter and value :)) and use it store all the odd bits of information like this which may change once in a blue moon, but which shouldn't be hard-coded all over the place.

    Would this be the steps I need to take:

    1. Create a table with 2 columns (parameter and value)

    2. Insert the following:

    SMTPConnection - XXXXXX.com

    From - XXXXX.XXXXX@XXX.com

    Now, what I dont understand is how do I call this information within SSIS? I dotn ahve an option to when I look at the "SendMail Task Editor"

    Thanks

  • March 25, 2009 at 5:26 am

    #965901

    Duplicate

    Derek

  • March 25, 2009 at 7:23 am

    #965966

    Why is there so may duplicates in this thread?

  • March 25, 2009 at 7:42 am

    #965979

    A Little Help Please (3/25/2009)

    Why is there so may duplicates in this thread?

    I'm seeing that all over the forums from yesterday. The site may have been having problems.

    - Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
    Property of The Thread

    "Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon

  • March 25, 2009 at 8:46 am

    #966013

    A Little Help Please (3/25/2009)

    Why is there so may duplicates in this thread?

    This morning it seemed that almost every time I posted I'd get a network error. I checked by refreshing the page, but post didn't seem to have been made so I tried again.

    It now seems that the posts were being made, but weren't showing up.

    I've tried deleting the duplicates, but the forum isn't doing it at present so I've just deleted the text so as not to confuse people.

    Derek

  • March 25, 2009 at 8:57 am

    #966026

    Does this help:

    http://sql-server-performance.com/Community/forums/p/3192/17035.aspx

    This was a hard one to research on.

  • March 25, 2009 at 9:35 am

    #966050

    Steve,

    Thanks, yes your right very hard!!

    Did you read my posts in reply to your comments earlier in this thread...

  • March 25, 2009 at 10:16 am

    #966090

    Yes it kind of helps, but again, does not really explain how it can be done.

    I know it can be done

  • March 25, 2009 at 11:51 am

    #966164

    OP poster, there are only two basic concepts about SSIS you need to research to understand the solutions provided here:

    1. storing results to a variable.

    2. using a variable in a task (such as Send Mail).

    These two things are essential to know to do many things in SSIS, as it one of the key ways to make the packages dynamic for many causes, and not just hard-coded chunks that have to be manually tweaked everytime something changes.

    The other solution provided here was a config file (XML), which can be read in also. However, XML never made much sense to me when you are usually sitting on top of a database... why go to a slower parsed format rather than just use the database: sometimes the packages are independent of database tables and can be run for complete out-of-the-box solutions, as SSIS is an extremely flexible generic task scheduler (albeit a little bloated for simple system tasks), and it allows you to use any custom code component, whether .NET centric or not that can run on the system in use.

    The description of how to do any of these is rather verbose, depending on the skills and understanding of the student.

    You may instead break the task down, one step at a time. If you research or ask questions on the individual steps, you may likely get more mileage. For example:

    First figure out how to create a package variable.

    Second learn how put results from a SQL Task into the variable(s).

    Third use that variable in your Send Mail task.

    None of these steps are particularly daunting. But as a whole, can appear to be so, and coming into it blind and not being able to see the whole picture, it looks far more bleak than it actually is.

    So create a table to house your changeable data and start with step one.

  • March 26, 2009 at 1:14 am

    #966445

    Hi,

    If you got different subject line and ToLine, FromLine etc for different send mail task then one option would be create that no. of variables in package and reefer them in Expression of send mail task.

    If you are still not done with solution then you can try XML solution.

    Following link may be helpful to you.

    http://www.mssqltips.com/tip.asp?tip=1434

    Regards.

Viewing 10 posts - 31 through 39 (of 39 total)

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