MySQL Connector/ODBC 5.3.8的SSIS问题 [英] SSIS problems with MySQL Connector/ODBC 5.3.8
问题描述
我在从MySQL数据库下载数据并将其插入SQL Server 2014数据库的SSIS项目中遇到问题.
I am having a problem with a SSIS project that downloads data from a MySQL database and insert it in a SQL Server 2014 Database.
因此，我有同一个项目的两个版本，一个用于SQL Server 2016，另一个用于SQL Server2014.它们具有相同的脚本和数据流，但是由于某些原因，只有为SQL Server 2016设计的版本可以工作.问题位于ODBC驱动程序连接器中.我可以在两个项目中预览数据，但是对于SQL Server 2014版本，它根本不会加载它.因此，每次运行它都会得到0行.不幸的是，我需要使用2014版的SQL Server，因为当我以2016年为目标版本部署项目时，它会失败.
So I have two versions of the same project, one for SQL Server 2016 and another one for SQL Server 2014. They have the same scripts and data flows, but for some reason, only the one made for SQL Server 2016 works. The issues resides in the ODBC Driver connector. I can preview data in both project, but for the SQL Server 2014 version, it simply won't load it. So I get 0 rows every time I run it. Sadly, I need the 2014 version for our SQL Server, since when I deploy the project with 2016 as target version, it fails.
这几乎可以概括整个问题，我已经尝试了很多事情.包括更改ODBC连接器的版本.当目标版本从2016年更改为2014年时，这似乎与Visual Studio有关.但是，我找不到解决此问题的解决方案.
This pretty much sum up the whole problem and I have try quite a few things. Including, changing the ODBC connector's version. It all seems it has something to do with Visual Studio, when the target version is change from 2016 to 2014. Still, I can't find a solution to this issue.
我正在使用查询来获取数据，但是我也尝试使用表名，但是仍然无法正常工作.我没有使用任何功能.我直接从Visual Studio以调试模式运行.
I am using a query to source data, but I also tried with the table name, but still didn't work. I am not using any function. I am running directly from Visual Studio in debug mode.
有人遇到过同样的错误吗?我找不到任何相关的东西.
Has anyone gone through the same error? I can't find anything related.
请让我知道您是否还需要其他任何信息来理解该问题.
Please, let me know if you need anything else to understand the issue.
推荐答案
好吧，我也遇到了类似的问题，但在源查询中，其中一个功能在2016年和2014年版本之间表现不相同.
Ok I had similar issue but it was in Source query where one of function was not behaving same between 2016 and 2014 version.
- 当您说0行时，表示打包失败还是成功?
- 您是否正在使用查询来获取数据?如果是，是否使用了任何功能?
- 您是从BIDS还是SQL Agent运行?如果是Sql Agent，请检查是否将代理作业配置为以相同的32位或63位版本运行?
这篇关于MySQL Connector/ODBC 5.3.8的SSIS问题的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
