3369355 - Error: [ODBC Driver 17 for SQL Server]Numeric value out of range row <row number>, col <col number> when loading data from MSS DB Connection datasource

When execute an infopackage from the DB connection type source system, got the errors:

Unknown error while uploading data from the DB table
Message no. RSDS_ACCESS027

Errors in source system
Message no. RSM340

OR

Interface EXTRACT_DIRECT not implemented by method DBEXTRACT
Errors in source system

And from ST11, you can see the following errors:

C  ERROR: 1 in function GetNextRow (fetch) [line 18528]
C  (99) [22003] [Microsoft][ODBC Driver 17 for SQL Server]Numeric value out of range row 1, col<col number>
C  ERROR: 1 in function GetNextRow (fetch) [line 18528]
C  (99) [22003] [Microsoft][ODBC Driver 17 for SQL Server]Numeric value out of range row 2, col <col number>
C  ERROR: 1 in function GetNextRow (fetch) [line 18528]
C  (99) [22003] [Microsoft][ODBC Driver 17 for SQL Server]Numeric value out of range row 3, col <col number>
......

The same ST11  errors can also be seen from datasource data preview(T-cd=RSDS -> Preview).

• SAP Netweaver BW Data Warehourse All Versions

STRING, Date, Proposal, ODBC Driver 17 for SQL Server, Numeric value out of range row, ERROR: -1 in function GetNextRowUsingGetData, sql error 99 performing FET , KBA , BW-WHM-DST , Data Staging , Problem