We set SQLWidthUpdate to ON without setting SQLTrncateTooLarge to anything. The default is ON which caused a lot of our queries to return bad data like duplciate records, and not all the records. It took a long time to realize that SQLWidthUpdate set to ON was not playing nice with the SQLTruncateTooLarge default of ON.
The following works: -SQLWidthUpdate ON -SQLTruncateTooLarge OUTPUT
But without adding on -SQLTruncateTooLarge OUTPUT, we get inconsistent results with our queries.