how to achieve this requirement

• prabhu.st

  SSCrazy

  Points: 2552

  More actions

  September 9, 2014 at 5:21 am

  #289940

  Hi,

  I have a requirement to move files from one folder to another, we can do it easily with "File System Task" in SSIS, but my difficulty is, I need to move the files based on the FileName.

  Example:

  source:

  c:\abc_log.txt

  c:\123_log.txt

  destination:(should be moved as per the filename like below)

  c:\abc\abc_log.txt

  c:\123\123_log.txt

  is there any inbuilt functionality with SSIS to achieve this.

  All your inputs are valueable..

  Thanks,

  Prabhu