• ODBC Error when SSIS package is run from SQL Job - Sage 2022

    Hi All. We're in the process of upgrading to Sage 2022 and I'm trying to recreate some SSIS packages (SQL Server 2019 and Visual Studio 2022) that connect to Sage 2022 via the ODBC 64-bit driver and copies to one of our SQL Server 2019 tables. I'm…
  • Intermittent "[ProvideX][ODBC Driver]Internal error"

    I am encountering an intermittent "[ProvideX][ODBC Driver]Internal error" within an Excel workbook containing several worksheets, each of which contains a Microsoft Query (MSQuery) to various Sage 100 Advanced v. 2019 PU 2 files/tables. The query results…