Hi everyone
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
SELECT
CustomerID,
CustomerName,
ProductID,
ProductName,
Store,
State,
SalePrice
FROM dbo.SALES
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.
BO