Post reply

Send .csv file automatically thru email

  • December 5, 2007 at 10:44 am

    #154001

    What is the easiest way to send a file thru email automatically? We have an opportunity to 1) create a file using SQL query from our database automatically and 2) sending this file to one recipient at a scheduled time every day without any user intervention.

    Is there an efficient and simple way to do this? I know I can create a job with the sql query but how can you get that to actually create a file to send?

    Thanks

  • December 5, 2007 at 2:15 pm

    #757446

    If you have reporting services running, it is a good solution to do this.

    Thats what I Have done in this scenario

  • December 6, 2007 at 1:39 am

    #757565

    hi

    if i understood your issue well....

    you could do it

    - in a DTS, with an Execute SQL task and a SendMail task and then schedule the package

    or if you want to stick to just a job and a script

    - using xp_sendmail

    i guess both should work just fine!

  • December 6, 2007 at 6:24 am

    #757624

    I was thinking DTS. Just have never used it. I found some good information in the Articles.

    Thanks for the input

  • December 6, 2007 at 11:21 am

    #757793

    i would choose DTS too 🙂

    i could try to help you if needed

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply