When importing data from MS SQL Server, the “Invalid descriptor index” error is raised like below.
Error in result_fetch(res@ptr, n) : nanodbc/nanodbc.cpp:3069: 07009: [Microsoft][ODBC SQL Server Driver]Invalid descriptor index
This could happen when you use an older ODBC driver. If this happens, please install the latest ODBC driver
https://www.microsoft.com/en-us/download/details.aspx?id=56567
And update your connection to use the ODBC driver
