Post reply

DTS Email Excel sheet

  • June 21, 2007 at 11:01 am

    #70198

    Hi All

     

    Iam trying to find a way to send an excel spreadsheet to an outlook email address .

     

    This could be done with the send mail task? is it right?

     

    Also the excel sheet name changes everyday usually its the date , so is there a better way of configuring this task?

     

     

    Thanks

     

  • June 21, 2007 at 12:13 pm

    #714435

    use the extended procedure xp_sendmail. Check BOL for the syntax.

  • June 22, 2007 at 6:33 am

    #714559

    You might want to look in to the xp_smtp_sendmail at http://www.sqldev.net/xp/xpsmtp.htm as an alternative to the SQL Server mail.

    As for the change in name, you could use an ActiveX script to detect the file and therefore the name; or you could, if you know the name (like it's the date formatted or something) you could use Dynamic properties before using send mail (if you still want to use that).


    Ade

    A Freudian Slip is when you say one thing and mean your mother.
    For detail-enriched answers, ask detail-enriched questions...[/url]

  • June 22, 2007 at 7:03 am

    #714568

    Thanks Adrian!

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

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