Post reply

SSIS XML XLS translation with timestamp error

  • May 11, 2019 at 2:28 pm

    #3640482

    Hi

    I am running a XML file against an style sheet translation which works fine. I then need to copy the file to another directory once completed. The issue is the XML file includes timestamp (HHMMSS) in the file name and when it's tries to copy the file it cannot be found, I guess it's looking for the file at that precise second which the file has been processed a few seconds earlier. Is there a way of the copying file can pickup the original file timestamp the processing started?

     

    Regards

    Raxso

  • May 11, 2019 at 10:50 pm

    #3640683

    Save the filename in an SSIS variable at the point where it is created, then use that in your subsequent copy.

    The absence of evidence is not evidence of absence
    - Martin Rees
    The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
    - Phil Parkin

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

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