Extracting data to multiple folders

• hoseam

  SSCertifiable

  Points: 5533

  More actions

  October 10, 2017 at 7:59 am

  #333251

  I'm Extracting data into a file, I have o send the same file to multiple directories. So far it's easy for me to output it into one file directory, and I'm thinking I can take same folder and copy it into other 4. Please on how can I do this or even the better way.

• Phil Parkin

  SSC Guru

  Points: 247159

  More actions

  October 10, 2017 at 8:11 am

  #1963003

  hoseam - Tuesday, October 10, 2017 7:59 AM

  I'm Extracting data into a file, I have o send the same file to multiple directories. So far it's easy for me to output it into one file directory, and I'm thinking I can take same folder and copy it into other 4. Please on how can I do this or even the better way.

  1) Data flow to file
  2) Copy file to other folders 
  (Use File System Tasks or a Script Task to do this)

  ---

• Steve Jones - SSC Editor

  SSC Guru

  Points: 738171

  More actions

  October 10, 2017 at 8:43 am

  #1963021

  Or PowerShell. Copy-File will help you.

• Phil Parkin

  SSC Guru

  Points: 247159

  More actions

  October 10, 2017 at 11:00 am

  #1963082

  Steve Jones - SSC Editor - Tuesday, October 10, 2017 8:43 AM

  Or PowerShell. Copy-File will help you.

  It would be nice if there were a native 'Execute Powershell' task in SSIS, but there isn't, so you'd need to use a generic Execute Process task to achieve this.
  I prefer Script Tasks mostly because you get comprehensive debugging built in.

  ---