What is the best way to bulk move files within SSIS?

• tripower

  SSCrazy

  Points: 2035

  More actions

  October 5, 2009 at 7:18 am

  #142274

  As part of my package I need to move files from one folder to another. What is the best way to bulk move files within SSIS?

• Erik Kutzler

  SSCarpal Tunnel

  Points: 4287

  More actions

  October 5, 2009 at 9:36 am

  #1061830

  A File System Task with it's Operation set to 'Copy File' inside of a For Each Loop Container.

  You'll have to set up variables to store your source & destination folder paths.