using SSIS to copy folders and files

• mulham-776460

  SSC Rookie

  Points: 32

  More actions

  January 23, 2009 at 1:33 pm

  #128173

  Hi I have this task:

  I have those files:

  c:\source\first\file1.txt

  c:\source1\second\file2.txt

  I want to archive those files to:

  f:\Archive\first\files1.txt

  f:\Archive\second\\file2.txt

  I created foreach loop container and configured an expression to return the source directory and enumerated the files , how should I configure the file system task to get this package working?.

  Thanks for your help.:)

• GSquared

  SSC Guru

  Points: 260824

  More actions

  January 23, 2009 at 1:36 pm

  #932025

  There's a Copy Files and Folders option on that. Just use that. It's pretty straightforward.

  - Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
  Property of The Thread

  "Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon

• mulham-776460

  SSC Rookie

  Points: 32

  More actions

  January 23, 2009 at 1:50 pm

  #932038

  Thanks Very much