locked
SSIS For Each Loop Container RRS feed

 > 

  • Question

  • Question
    Sign in to vote
    0
    Sign in to vote

    Hello All,

    I have some files within sub folders. Below is the layout 

    C:\Source\01012015\Sample_1.csv
    C:\Source\01012015\Sample_2.csv

    C:\Source\02012015\Sample_1.csv
    C:\Source\02012015\Sample_2.csv

    C:\Source\03012015\Sample_1.csv
    C:\Source\03012015\Sample_2.csv

    I want to copy entire folder contents from source to destination including the sub folders and the files

    I am using for each loop container which reads the files form 01012015 folder, is there any way to read all the files from each and every folder(01012015, 02012015,03012015)?

    The destination should be like this. 

    C:\Archive\01012015\Sample_1.csv
    C:\Archive\01012015\Sample_2.csv

    C:\Archive\02012015\Sample_1.csv
    C:\Archive\02012015\Sample_2.csv

    C:\Archive\03012015\Sample_1.csv
    C:\Archive\03012015\Sample_2.csv

    Thanks, Shyam.


    • Edited by ShyamReddy Thursday, April 2, 2015 5:40 PM
    Thursday, April 2, 2015 4:36 PM

Answers

All replies