Replace function in SSIS Expression

• komal145

  SSCrazy Eights

  Points: 9920

  More actions

  July 15, 2022 at 10:27 pm

  #4064019

  hi,

  I have files that are coming in .txt files. Example  MA.textfile1.txt ,MA.textfile2.TXT . I need to replace the file name after i process these files.

  I have a foreach loop to get the file names , and file system task to rename files.

  However i have set up variables within file system task, if i find .txt in filename , use Replace function to convert it to .bak.

  However i figured out that REPALCE function is case senstive. Because my expression is something liek below.

  REPLACE(@USEFILENAME,".TXT",".BAK")

  SO, it converts only the file has .TXT in uppercase. If i come across file with lower case .txt it is not converting.

  Please suggest me the solution, if i can rewrite this expression , to just check .txt/.TXT file whether it is in lowercase or uppercase.

   

   

• TangoVictor

  SSChampion

  Points: 10976

  More actions

  July 15, 2022 at 10:32 pm

  #4064020

  Just use REPLACE(UPPER(@USEFILENAME),".TXT",".BAK") then you don't need to worry about case.

• komal145

  SSCrazy Eights

  Points: 9920

  More actions

  July 18, 2022 at 4:59 pm

  #4064880

  Thanks. It worked.