SSIS Iterate through file path and load content from file

Hello, 

 

You can use the conditional split or script component to accomplish your requirement.

Please check the below link to understand more -

 

https://stackoverflow.com/questions/27750108/how-to-parse-a-text-file-in-ssis

 

https://docs.microsoft.com/en-us/sql/integration-services/extending-packages-scripting-data-flow-script-component-examples/parsing-non-standard-text-file-formats-with-the-script-component?view=sql-server-2017

 

hope it will help you