Home Forums SQL Server 2005 T-SQL (SS2K5) Move file from one Directory to other RE: Move file from one Directory to other
bob.lawson
Old Hand
Points: 319
More actions
October 31, 2013 at 12:54 pm
#1663234
I use these in several stored procs. Looks like you are missing a null.
Your code:
EXEC @RetCode = sp_OAMethod @oFol, 'MoveFile' , @Path,@Path1
Try adding a null.
EXEC @RetCode = sp_OAMethod @oFol, 'MoveFile' , NULL, @Path,@Path1