SSIS - Move List of Files from One Folder to Another
<p>I have a folder SourceFolder with about 10,000 PDF documents.</p>

<p>I have a list (FileList.csv) with the names of about 1,000 of those files.</p>

<p>I want to move the files on that list from the folder they are in to an empty folder I have created (DestFolder). I am using SSIS 2013.</p>

<p>As a Proof-of-Concept, I successfully configured a ForEachLoop container using a ForEachItem Enumerator with a FileSystem Task inside, and moved 2 of the files.</p>

<p>However, I had to enter the filenames by hand in the ForEachLoop Editor --> Collection --> Enumerator Configuration window.</p>

<p>I have Variables configured for FileName, SourceFolder, and FullSourcePath, and everything works.</p>

<p>My question is - How can I connect to the flat file to get the filenames into the variable?</p>

<p>I'm not allowed to post images, so I will try to explain what I have tried.</p>

<ol>
<li><p>adding a flat file source and Connection manager and using the Expressions in CM Propoerties to assign the FileName variable to Connection String (no luck)</p></li>
<li><p>Feeding the FlatFile Source into a RecordSet Destination and assigning the result set to an ObjectVariable, ANd changing the ForEach Loop Container configuration to ForEach ADO Enumerator, with ObjectVariable assigned to ADO Source Object variable (no luck).</p></li>
</ol>

<p>This seems like such a simple task, I hope I am missing something obvious. Aopologies for not including images.</p>