Copying Files

• tmmutsetse

  Hall of Fame

  Points: 3669

  More actions

  June 14, 2018 at 1:06 pm

  #406697

  Hi Experts,
  Is there a way i can copy a file to multiple directories using ssis? 

  Thanks

• Thom A

  SSC Guru

  Points: 99143

  More actions

  June 14, 2018 at 1:11 pm

  #1994058

  Yes, there is! Use several file system tasks, or a loop with a changing variable value.

  Thom~

  Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
  Larnu.uk

• Phil Parkin

  SSC Guru

  Points: 247161

  More actions

  June 14, 2018 at 1:19 pm

  #1994059

  Thom A - Thursday, June 14, 2018 1:11 PM

  Yes, there is! Use several file system tasks, or a loop with a changing variable value.

  Or a Script Task, or an Execute Process task.

  ---