SSIS XML XLS translation with timestamp error

• Raxso1

  SSC Veteran

  Points: 272

  More actions

  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

• Phil Parkin

  SSC Guru

  Points: 247119

  More actions

  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.

  ---