Post reply

changing export file name every week when it is sent

  • October 23, 2009 at 12:06 pm

    #211338

    I have an excel file that is being sent every week to emails from reporting services with the name abc_123.xls.

    Now I need to change the naming convention to abc_123_mmddyy.xls.

    So every week the the last part of the file name should change .

    Eg:abc_123_010109.xls

    Next week it should be abc_123_010809.xls

    then abc_123_011509.xls

    how do I achieve this.

    Thank you

  • October 27, 2009 at 12:19 am

    #1071038

    According to my knowledge, you can change the attachment name only in data-driven subscription. data-driven subscription is available only in enterprise edition not in standard

    -----------------------------------------------------------------------------------------------------------------------------------------------------------
    Please feel free to let me know if you are not clear or I’ve misunderstood anything.

    Thanks,
    Arunkumar S P

  • October 28, 2009 at 3:39 am

    #1071600

    Use subscriptions

    Select delivery type as windows file share and set name & path

    Set overwrite option as

    Do not overwrite the file if a previous version exists

    this will create a new file with same name but with version number at the end of file name

    filename_1, filename_2 ....

Viewing 3 posts - 1 through 2 (of 2 total)

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