For our migration with a new customer we've had to load enriched data from outside the system into dynamics. Since DIXF is the only supported technology of importing data, we copy the data into a data entity package. The import of this package to staging will often fail because of SSIS data violation issues. The execution error details form only lists the columns on which the failure occurred. But it won't tell you which line (line number or actual full line in text) specifically, so you're left in the dark to what exactly you need to fix to get it into staging. The only way right now to find out what failed is by splitting up the data archive into multiple smaller files and keep loading these until you hit a package with at least one bad line. Very cumbersome and frustrating.