I'm pretty much a very beginner in SSIS, still didn't familiar with the tools, but currently working on it. And i got an idea, how to insert the filename? because i think it'd be a great information since it'll give the information about the file path where i extract the data from.
I've already searched most of it but still didn't really get me there.
You would need to build up your "ConnectionString" and/or Filename in a variable. Then you can assign the variable in a "Derived Column" Task in your "Data Flow" as a new column. That will be added to the rest of the columns that you can map to your output.