renaming txt file with date and time

• krypto69

  SSChampion

  Points: 13604

  More actions

  August 31, 2012 at 6:56 am

  #281054

  I have a txt file that is being produced from a vendors SSIS package named - 'ADPTranP.txt'.

  I need to create a new SSIS package that renames the txt file to:

  p.gsg1.tax.yyyymmddhhmmss.prl.pgp

  I have a handle on the pgp encryption part, but don't know how to do the renaming.

  Pretty sure I will need to create package variables to handle this. But I'm fairly new to SSIS and really need step by step instructions, if possible.

  Is there a guide already out there that would help me? Any help appreciated.

  Thanks in advance.

• kl25

  Hall of Fame

  Points: 3752

  More actions

  August 31, 2012 at 8:33 am

  #1532428

  Check the approaches discussed here:

  http://www.sqlservercentral.com/Forums/Topic560772-148-1.aspx