How to find which flat file contains data errors while loading multiple flat files using Foreach File enumerator in SSIS

user_7236309 0
Viewed 85

I have a question in SSIS. For an instance, I have 100 flat files of the same metadata columns to be loaded using an incremental load, but my question is how can we find which flat contains error data while loading using for each loop container. Any solution can be appreciated

foreach-loop-container flat-file etl ssis sql-server
1 Answers

Simplest solution: Since you are using a Foreach Loop container, then the file path is mapped to a variable. You can simply add a Derived Column Transformation and use this variable within the expression as following (assuming the variable name is FilePath):

@[User::FilePath]

Then insert it with the erroneous rows.

user_70312300
Related