Rename File Through SSIS

• Slick84

  SSCertifiable

  Points: 5602

  More actions

  February 1, 2010 at 12:17 pm

  #144742

  Hi,

  I found alot of renaming of files through SSIS articles on Google and posts even here.

  However, my problem is a little different. I'd like to find out how I can rename a SQL backup file. The scenario is I want to pick up a timestamped file from a folder.. and then restore it. On my restore process I have to specify a specific name so I need to always rename the timestamped backup file to a static name such as 'MyDataBase.bak'.

  So right now using the above example, I have 'MyDatabase_01302010.bak' backup file. I want to rename this to 'MyDatabase.bak' everytime.

  I am using 2 connection managers. One that picks up an "Existing File" called "SourceConnMgr" and the second one that dumps a renamed "Created File" called "DestinationConnMgr". However in the "SourceConnMgr", how do I define what file for it to pick up? If I do "MyDatabase_*.*" it doesn't work.

  Thanks,

  S

  --
  :hehe:

• COZYROC

  One Orange Chip

  Points: 28499

  More actions

  February 4, 2010 at 10:14 am

  #1113848

  You can use standard Foreach Loop where you can specify wildcard. The loop will hopefully do one iteration and you can rename current iterated item to your destination static name.

  ---
  SSIS Tasks Components Scripts Services | http://www.cozyroc.com/