How to export multiple copies reoprts based on parameters and with pre-defined naming

I feel if you can store branch name as a configuration entry in some table (I mean update) then you can do this activity in SSIS. Read the branch name from config table and accordingly generate file name in File connection connection string dynamically and use FTP task to upload the file. Put this in a for each loop container since you are expected to do the same for multiple files.

---

http://www.bifeeds.com