SSIS

SQL Server Administration, and tips for Integration Services (SSIS) and Analysis Services (SSAS)

Datos inmemory en SQL Server 2014This SQL Server eBook compile our best articles about SQL Server administration and development, including posts about Database Administration, for SQL Server DBA's, and about the Business Intelligence components of the Database, the ETL tool SQL Server Integration Services (SSIS) and the OLAP tool SQLServer Analysis Services (SSAS).

 

SSIS: Workaround to two errors for no apparent reason when we insert data in MySql

Up
0

SSIS: Workaround to two errors for no apparent reason when we insert data in MySqlFor whatever reason we may have to develop a Microsoft Integration Services package we move data from any source to a table that is in a MySQL database.

The first aim will do so through an ADO.NET Destination and MySQL provider for the connection. If we do well to insert the data directly, to create the target, select the connection and then select the table appears an error like the following check everything with the preview or try and do the assignments...