Create a SSIS Package for Sql server 2008 that allows us to export data from a specific table to excel format, and then email that excel document to a contact person.
Use the following SQL as a dummy:
SELECT * FROM Products WHERE Date BETWEEN [FirstOfMonth] and [LastOfMonth]
This SSIS package should run the first day of every month and select data from the previous month. The SSIS Package should dynamicly enter the [FirstOfMonth] and [LastOfMonth] values as this should be allowed to run automaticly without us entering the start and end-dates.
So if this was to run juli 1, the SQL would look like:
SELECT * FROM Products WHERE Date BETWEEN '2009-06-01' and '2009-06-30'