Forum Replies Created

Viewing post 1 (of 1 total)

  • RE: Naming Txt File with timestamp and Name from Lookup tbl

    Would this help:

    DECLARE

    @fileTimeStampVARCHAR(500),

    @cmdTextVARCHAR(500),

    @rootSourceFileVARCHAR(500),

    @fullSourceFileVARCHAR(500),

    @destinationFileVARCHAR(500)

    --Start with file supplied by established operations

    SET @rootSourceFile = 'C:\Files\SourceFileName'

    SET @fullSourceFile = 'C:\Files\SourceFileName.txt'

    --Get the time to stamp it with, then clean it up to YYYYMMDDHHMMSSMMM

    SET @fileTimeStamp =...

Viewing post 1 (of 1 total)