Skip to content Skip to sidebar Skip to footer
Home / Etl / Sql / Ssis

Ssis Problems With Mysql Connector/odbc 5.3.8

Post a Comment
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. So I have two versions of the same project, one for

Solution 1:

Ok I had similar issue but it was in Source query where one of function was not behaving same between 2016 and 2014 version.

  • When you say 0 rows, does package failed or successful ?
  • Are you using a query to source data ? If yes, does it have any functions used ?
  • Are you running from BIDS or SQL Agent ? If Sql Agent, Check if agent job configured to run in same 32bit or 63 bit version ?

Post a Comment for "Ssis Problems With Mysql Connector/odbc 5.3.8"