Attached is a photo of the container in question of my package. Essentially, I am simply taking a flat file, doing a few transformations, and then sending it into a SQL Server database. However, some of the files have different formats, so I added a Failure Constraint to move the files which don't fit the original table into their own data flow. The alternate data flow is essentially a copy of the original, save for its different format, mappings, and destination. However, everything seems to work fine in the package. My only dilemma is that After taking the Failure Constraint route, the container completes successfully but fails to continue looping through the other files. I imagine this must simply be a setting, but I have not been able to figure it out. Anybody know the solution?
Thank you very much in advance for your help.