We help IT Professionals succeed at work.
Get Started

SQL when moving files with xp_cmdshell, it misses some of them - SQL Server 2005

1,024 Views
Last Modified: 2012-05-11
Hello experts,

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:

@filename varchar(255)
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?

Thoughts?

Thanks!
Comment
Watch Question
CERTIFIED EXPERT
Commented:
This problem has been solved!
Unlock 1 Answer and 7 Comments.
See Answer
Why Experts Exchange?

Experts Exchange always has the answer, or at the least points me in the correct direction! It is like having another employee that is extremely experienced.

Jim Murphy
Programmer at Smart IT Solutions

When asked, what has been your best career decision?

Deciding to stick with EE.

Mohamed Asif
Technical Department Head

Being involved with EE helped me to grow personally and professionally.

Carl Webster
CTP, Sr Infrastructure Consultant
Ask ANY Question

Connect with Certified Experts to gain insight and support on specific technology challenges including:

  • Troubleshooting
  • Research
  • Professional Opinions
Did You Know?

We've partnered with two important charities to provide clean water and computer science education to those who need it most. READ MORE