I'm still new in SSIS,
Now I can read the SQL Statement, FileName, and FileLocation based on this video.
But I'm facing the problems when export the flat file base on the File Location in SQL Table.
Here with my sample package
https://github.com/cheahengsoon/SSISPackage
& here with sample database Different FileName, Different File Location and different SQL Command