Archiving text files in SQL Script

• Andrew Dove

  SSC Veteran

  Points: 280

  More actions

  November 5, 2004 at 5:19 am

  #61363

  I need to pass a file name to a command in T-SQL and then have it move the file to another directory, is this possible?? 

  Alternatively if there is a process whereby I can move the entire contents of a directory to another location it would be workable but I would prefer the first one.

  If anyone has any ideas I would really appreciate it.

  Thanks

  Andrew

• Ste_P

  SSCarpal Tunnel

  Points: 4430

  More actions

  November 5, 2004 at 8:38 am

  #529114

  Hi Andrew,

  You can happily use the xp_command shell e.g:

  EXEC Master..xp_cmdShell 'MOVE "\\Server\Drive\Dir\*.xls" "\\Server\Drive\Dir\Archive\"'

  EXEC Master..xp_cmdShell 'DEL "\\Server\Drive\Dir\*.xls"'

  Have fun

  Steve

  We need men who can dream of things that never were.

• john-132685

  SSCertifiable

  Points: 6134

  More actions

  November 5, 2004 at 1:35 pm

  #529158

  Don't forget to check dos errors using the return from cmdshell (assuming the platform suppoorts it).

  declare @err INT

  EXEC @err = master..xp_cmdshell ...

  IF @err <> 0 PRINT "oops, so much for trying"

  just because your doing a kluge doesn't mean you have to be sloppy about it...