Home Forums SQL Server 7,2000 General How to add a timestamp to a file generated by a DTS package? RE: How to add a timestamp to a file generated by a DTS package?

  • Hey Artoo,

    Modify the script to set the time/date to the file name . . .

    http://msdn.microsoft.com/en-us/library/t0aew7h6(VS.85).aspx

    (Language Reference)

    http://msdn.microsoft.com/en-us/library/d1wf56tt(VS.85).aspx

    DatePart

    http://msdn.microsoft.com/en-us/library/4kt42529(VS.85).aspx

    i.e.

    oDom.Save "C:\PC\XML\testxml-" & DatePart("yyyy",NOW) & "-" & DatePart("m",NOW) & "-" & DatePart("d",NOW) & ".xml"

    I briefly tested this with WSH & msgbox . . . seems to work . . .

    (I didn't test it with the XMLDOM object though)

    hope this helps,

    M

    Free Expert Advice . . .
    http://xkcd.com/627/

    Mark