Append multiple file names

• Erin.

  SSCertifiable

  Points: 5237

  More actions

  December 28, 2010 at 7:53 am

  #229100

  I have multiple files that contain data from a soon to be extinct application. Each file is named differently. I would like to keep the original file name but append the application name to the front. For example, 'xxx_yyyy_1.doc' would become 'application - xxx_yyyy_1.doc'. There are over 1,900 files and each xxx_yyyy part of the file name is different.

  Any help would be appreciated.

  Thanks.

• Koen Verbeeck

  SSC Guru

  Points: 259105

  More actions

  December 28, 2010 at 8:05 am

  #1266736

  You can either use a script task (use the FileInfo class of the IO namespace) or you can use the File System Task to rename the files.

  Use a For Each Loop to loop over all the files.

  Need an answer? No, you need a question
  My blog at https://sqlkover.com.
  MCSE Business Intelligence - Microsoft Data Platform MVP