Is it possible to either print or e-mail query results?

[woody66]

Firstly I have to admit that I am still quite new to SQL.

I have a small database, 1 table actually, I have created a DTS package that basicially runs a query to give me a count on certain records. I know I can schedule this DTS to run at certain times, but I would like to either print or e-mail the results from within the DTS package.

Is this possible and if so how would I go about doing it? If not, how do you suggest that I do this?

Thanks in advance for any help.

Jon

 

[katehol]

If you go to the 'Query' menu and then go to 'Results to' > 'Results to Text' (or Ctrl + T) then run the query, it will come out as a text file - this can then be printed in the normal way (ie Ctrl + P)
Hope that helps

 

[woody66]

Hi Thanks for the reply, but I was hoping to be able to automate the task of printing instead of manually going and running the query and then printing it.

Jon