We help IT Professionals succeed at work.

SISS:  Need a tutorial on how to point to a folder, grab any file, and rename it

Jim Horn
Jim Horn asked
on
Hi All

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.
Jim
Comment
Watch Question

Sr. BI  Developer
Commented:
See if that helps you... LINK
Jim HornSQL Server Data Dude
Most Valuable Expert 2013
Author of the Year 2015

Author

Commented:
... looking ...
thanks for the quick response
Jim HornSQL Server Data Dude
Most Valuable Expert 2013
Author of the Year 2015

Author

Commented:
Exactly what I needed.  Thanks again.  -Jim
Jason YousefSr. BI  Developer

Commented:
You're welcome, thanks for the points and the grade..have a great day.. :)