I'm currently evaluating the use of TPT for load jobs in a DWH environment. One of the basic problems is that we often have a random number of blanks at the end of the data row in the input file. This can't easily be changed because the files are delivered from several different systems.
With TPT 13.10 there was no way to load these files, now with TPT 14.00.00.05 the new attribute AcceptExcessColumns has been introduced.
Now I'm facing 3 problems with that parameter:
Any help would be great!
#2 and #3 are bugs we are currently fixing.
For #1, the AcceptExcessColumns was originally only intended for the "delimited" data.
We will not be supporting that feature for the other record formats in 14.10, but will revisit the issue in the next release.