Post reply

Add Datetime Stamp to the excel Destination File

  • October 4, 2011 at 6:27 pm

    #148725

    Hi all,

    I want to add datetimestamp to my excel file name

    Filename: Nuetraltables_disposition.xls

    Expected Filename should be:

    Nuetraltables_disposition_10042011 02:56:00:.xls

    Any help will be appreciated

  • October 4, 2011 at 10:06 pm

    #1390491

    What method are you currently using to create your file name?

    Add a variable with the datetimestamp and an expression on the filename of your excel output.

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

  • October 5, 2011 at 2:02 pm

    #1390926

    I am using ssis- file system task

    need the query which will give me the expected result

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

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