Business Intelligence #02a: Developing a Query-Driven E-mail Delivery System

Sign in to queue

The Discussion

  • User profile image
    ZachSkyles​Owens

    We are really interested in your feedback on Developing a Query-Driven E-mail Delivery System.

    What would you like to see done differently?

    What do you think worked well?

    Feel free to leave a comment here or reply privately.

  • User profile image
    crowsol

    This is an excellent SSIS demo. I am going to use the ideas  to create a billing notification system for clients of my website development business. I will use an SSIS package similar to the one shown in this demo together with SQL Server Agent to schedule package execution. I will automatically send emails letting my customers know when their payments are due, when their payments are late and when their accounts are suspended (hopefully we will never reach that point). Thanks for the demo! I can't wait to watch the rest of the series.

  • User profile image
    ZachSkyles​Owens

    Thanks for the feedback.  That’s great to hear that this may directly influence your product! 

    SSIS can be a powerful tool and have uses beyond basic ETL.  If your product is something that you sell commercially you may want to update your Channel 9 profile with a link to your web site so other readers can see what you are building.

    Enjoy the other screencasts and let us know what suggestions you have for improvement.

  • User profile image
    ZachSkyles​Owens

    There is apparently an issue with the way these videos are encoded and Silverlight player...  You can watch these videos by clicking on the "Downloads" link then selecting "WMV".  I'll see what I can do to get this fixed.  Sorry for the inconvenience.

Add Your 2 Cents