Post reply

SSIS Failing when I run for to send email out with attachments

  • March 4, 2020 at 6:48 pm

    #3731015

    Hi Jeff,

    Finally got my package fully functional and working another question is the report I'm sending weekly  as of right now my subject line shows 'DC Transfers Report' how can I have the date in there for each week it sends? That way every week my job runs it will put the dates for the report.

  • March 4, 2020 at 9:07 pm

    #3731079

    etvph81 wrote:

    Hi Jeff,

    Finally got my package fully functional and working another question is the report I'm sending weekly  as of right now my subject line shows 'DC Transfers Report' how can I have the date in there for each week it sends? That way every week my job runs it will put the dates for the report.

    You have concatenated strings in other parts of this code.  See if you can figure out how to do this.

    Here are some hints.  These are built in SQL functions:

    CONVERT

    GETDATE()

    DATEPART

     

    Michael L John
    If you assassinate a DBA, would you pull a trigger?
    To properly post on a forum:
    http://www.sqlservercentral.com/articles/61537/

Viewing 2 posts - 16 through 16 (of 16 total)

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