We're running into quite a strange occurrence here, and hope someone can help. We have a small script here that is designed to simply pick up .TIF images from one folder, and move them to another folder. Our program reads in a .csv file with the file names to be moved, and then runs:
Currently calling a SP that uses SQL's XP_CMDSHELL function to move files from one static directory to another when given a variable filename:
EXEC xp_cmdshell 'MOVE "C:\Start' + @filename + '" C:\End'
We found that when the move was complete, we started with 500 files in folder 1, and when we counted folder 2, there were only 420. All 500 had been removed from folder 1 though. Not sure how 20% of them had been seemingly erased?