Error inserting in Mysql from Sql Server2014 with SSIS

Navigation
0

I am using an Integration Services with VS 2013 and Sql Server 2014 I want to export data from a Sql Server table to Mysql but it gives me an error and I will export to another database in Sql Server and also to execel 2016 and I will not no problem look and I saw that it had to put in true the option of retainsameconnection but I still can not insert the data because if I indicate that I create a new table if it does in Mysql but does not insert.

    
asked by wltr07 12.03.2018 в 20:01
source

1 answer

0

It is very likely that you will have to add a Data Conversion component to convert the data types and make it compatible between the two database engines.

    
answered by 13.03.2018 в 14:10
use excelrest with prtocolo https How can I create several global variables in Winforms C #?