ssis 错误Note 39022:MySQL client ran out of memory

通过ODBC查询Mysql数据库时候，可能会遇到和下面相似的问题。

  [MySQL][ODBC Driver]MSQL client ran out of memory

要修正这个错误，可以按如下方法设置你的ODBC连接：

1. Navigate to your ODBC administrator (Start ► Settings ► Control Panel ► Administrative Tools ► Data Sources (ODBC)).
2. Highlight the ODBC data source and choose Configure.
3. Click the Advanced tab; then select the Flags 2 tab. Place a check mark beside Don’t Cache Result.
4. Click OK.

转载于:https://www.cnblogs.com/moonunit/p/9447115.html