Post reply

SQL Script Output to EXCEL - How?

  • May 5, 2008 at 12:11 am

    #93356

    I would like to create a SQL job that runs a basic query monthly and saves the results as a .xls file and emails the results to a user. I've been unsuccessful with sp_send_dbmail in that the output file is always a single column. Any suggestions?

    Thanks, Dave

  • May 5, 2008 at 8:48 am

    #810730

    Hi Dave,

    Have you tried using Integration Services?

    I did something similar & it's pretty reliable.

  • May 5, 2008 at 9:20 am

    #810760

    I'd suggest using the data export wizard, saving the package, and then adding the email task.

  • May 5, 2008 at 9:58 am

    #810788

    Steve Jones - Editor (5/5/2008)

    I'd suggest using the data export wizard, saving the package, and then adding the email task.

    Exactly what I did 😉

  • May 5, 2008 at 2:04 pm

    #810904

    I'll give it a try.

    Thanks

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

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