I have to send invoices to our customers each month which is a time consuming manual process ;(
The invoices are created by running the following SQL
WHERE CustomerID = '1234'
Currently, I have to painstakingly run the script for each customer, paste the output from SSMS into Excel and save the file as [Customer name].Monthly Invoice [Month Name and Year].xls
I know there must be an SSIS solution but really need help in trying to put this together - any pointers, articles, script would be greatly appreciated.