Post reply

SSIS Email Sample

  • August 21, 2009 at 1:04 am

    #132802

    Dear Forum

    I am a little new to SSIS so please forgive my ignorance.

    I have a small project where every month i need to email various recipients depending on values within the table.

    I am OK with extracting the data I require but have no knowledge of SSIS.

    Is there a member who could guide me or pass a sample SSIS package that mails the result set of a query dynamically based on email addresses returned by the query.

    For example

    each row of data would have columns with the persons email address and the subject and body.

    Thank you all in advance

    With Kind Regards

    Paul Marks

  • August 21, 2009 at 1:17 am

    #1042629

    Hi Paul ,

    IMO SSIS is a bit of a beast and has quite a steep learning curve.

    You can email direct from sqlserver though , i would suggest taking that route unless you have a specific reason not to.

    http://www.databasejournal.com/features/mssql/article.php/3626056/Database-Mail-in-SQL-Server-2005.htm


    Clear Sky SQL
    My Blog[/url]

  • August 21, 2009 at 1:19 am

    #1042630

    Thank you for your reply.

    If i have a SP am i able to schedule the execution from SSIS?

    As this would probably resolve my issue

    With Kind Regards

    Paul

  • August 21, 2009 at 1:21 am

    #1042631

    Thank you for your reply.

    If i have a SP am i able to schedule the execution from SSIS?

    As this would probably resolve my issue

    With Kind Regards

    Paul

  • August 21, 2009 at 1:28 am

    #1042633

    SqlAgent is responsible for executing and scheduling tasks, so again SSIS is not needed.


    Clear Sky SQL
    My Blog[/url]

  • August 21, 2009 at 2:05 am

    #1042647

    Thank you so much for your guidance. Greatly appreciated

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

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