We have exported data to a file using a pipe delimiter. The file is formatted correctly. There are no dupes and the table that it is being imported into has a unique key.
TDP cannot import the file and is erring on every row. If we import it through another system it imports into the same table without a hitch. We have the logs in verbose mode, but the only thing they can tell us is that it's erring on every row.
How can we troubleshoot something like this given that the delimiter encounters no errors when the import wizard is configured?