What I am attempting to do is keep an externally configured list that is consumed by an enumerator. That isn't a database table. I haven't given up on finding a useful case for the FEFVE, but as I have slightly more than a month before my project is due, I need to take a working path and run with it.
The solution I'm going to go with is fairly simple. I have a script task that will take my input string and transform it into a simple XML blob. That blob will be shredded by an Foreach Nodelist Enumerator and voila it's done. And really, I spent more time trying to build my XML using the real libraries instead of cobbling together strings than it took to wire the enumerator up.
Given a starting value of FileList:Foo.txt;Bar.txt;Blee.txt
The Script task will generate output of
An interesting thing to note, I am using a semi-colon as my delimiter. Assuming I tried to set the value at runtime via dtexec, the not-entirely-intuitive manner of escaping the semicolon is to put it all in quotes. And then escape the quotes.
C:\>dtexec /File XMLEnumerator.dtsx /Set \Package.Variables[User::FileList].Properties[Value];\"A.txt;b.txt;c.csv;d.dat\"
The package has been uploaded to my skydrive
In memory XML Build a formatted XML document in memory by using an XmlTextWriter in VB .NET
Foreach Nodelist Enumerator SSIS ForEachNodeList Container by Example (Part 1)