I just did a ForEach Loop through a number of files, and within the
loop I did a Data Task using a Flat File Source and a SQL Server
Destination.

I used the same ForEach Loop, and within the loop I did a Data Task
using a Flat File Source and a OLE DB Destination.

The interesting part is that the SQL Server Destination failed after a
few files (not sure why) but the OLE DB Destination had no errors and
imported everything.

Anyone know why that is? Also, how do I get to read error messages
generated by a failed package? SQL Server Destination has no error
output settings.

Thanks