is it possible to use send mail task to send results of a query via email if it can be sent then what would the result look like will it be like excel type format or fixed length or comma delimited
and obviously -- how can I accomlish it
Every day I would like the script below to run at 3pm
select * from dbo.BTStandardLoadDetail
I would like the data from this script be sent to an email to the persons I choose.
How to do this all in a script ?