Rename a File in SSIS (SSDT) using an expression

• Welsh Corgi

  SSC Guru

  Points: 116520

  More actions

  July 23, 2015 at 10:27 am

  #299108

  I have a file named abc-72015.txt.

  I have a package that renames the file from abc.txt to abc-72015.txt

  I want to do the reverse. I wan to rename it from abc-72015.txt to abc.txt.

  I have a variable named myFileValue with a value of abc.txt.

  Can I do this by setting the variable as an expressions and use a function to rename it as abc.txt?

  What would the syntax be?

  Do I need to anything else?

  For better, quicker answers on T-SQL questions, click on the following...
  http://www.sqlservercentral.com/articles/Best+Practices/61537/

  For better answers on performance questions, click on the following...
  http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

• Welsh Corgi

  SSC Guru

  Points: 116520

  More actions

  July 23, 2015 at 10:49 am

  #1814458

  I tried the following but I got an error?

  Substring( @[User::MyFileValue] ,1,3)

  The variable User::MyFileValue was not found in the variables collection. The variable may not exist in the correct scope.

  For better, quicker answers on T-SQL questions, click on the following...
  http://www.sqlservercentral.com/articles/Best+Practices/61537/

  For better answers on performance questions, click on the following...
  http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

• Welsh Corgi

  SSC Guru

  Points: 116520

  More actions

  July 23, 2015 at 11:05 am

  #1814465

  I used the following example to rename the file from abc.txt to abc-72015.tx:.

  [/

  http://www.rafael-salas.com/2007/03/ssis-file-system-task-move-and-rename.html

  url]

  I need to do the reverse:

  abc-72015.txt to abc.txt

  For better, quicker answers on T-SQL questions, click on the following...
  http://www.sqlservercentral.com/articles/Best+Practices/61537/

  For better answers on performance questions, click on the following...
  http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

• Eirikur Eiriksson

  SSC Guru

  Points: 182947

  More actions

  July 23, 2015 at 11:30 am

  #1814477

  Quick thought, you can either do a copy/rename snd a delete with a file system task or a rename with a scipt task an file system objecr.

  

• Welsh Corgi

  SSC Guru

  Points: 116520

  More actions

  July 23, 2015 at 12:10 pm

  #1814499

  I am using a File System Task.

  The Package is located at the following URL

  [/

  http://www.rafael-salas.com/2007/03/ssis-file-system-task-move-and-rename.html#comment-form

  url]

  I want to rename import20150723.txt to import.txt

  For better, quicker answers on T-SQL questions, click on the following...
  http://www.sqlservercentral.com/articles/Best+Practices/61537/

  For better answers on performance questions, click on the following...
  http://www.sqlservercentral.com/articles/SQLServerCentral/66909/