Can someone point me to a tutorial that demonstrates in SSIS 2008 (using For Each Loop Container?) how to..
* Point to a folder
* Search for a file in that folder (should only be one), whose name will always be different
* Rename it to the same name (say foo.xml)
Thanks in advance.