I am running dts script from DB2 on AS/400 to SQL Server. If I use
"iSeries Access ODBC Drive" by setting up DSN, then I get complete
records. However, if I use linked server via "Microsoft OLE DB Provider
for ODBC Driver" calling same DSN (as above), then I get incomplete
records. FYI, the linked server property doesn't let me choose "iSeries
Access ODBC Drive" as provider.
Just clarify complete records vs. incomplete records...
I know that query should bring in 147 records, but the incomplete records
only bring in 101 records.