Problem with bigint and Devart MySql Destination and SSIS

[iznogood]

Hi

I'm using 8.3.215

I try to move data from MS SQL Server to MySql, if the table have a BIGINT, I got an error when doing Column Mappings in the Advanced Editior.

System.ArgumentException: Value does not fall within the expected range
.............. ,NewAt(Int32 IIndex)
.................ReinitializeMetadata()

- When I make a simple datatransfere with a ADO NET Destination and the Devart driver it works
- When I make a simple datatransfere with a ADO NET Destination and the Devart driver it works.
- When I make a Devart MySql Destination with version 8.2.103 it works.

regards
Jesper

[Pinturiccio]

We could not reproduce the issue. In our development environment both dotConnect for MySQL versions, 8.2.103 and 8.3.215, Column Mappings don't generate an error in the Advanced Editor when a table has a column of the BIGINT type.

In order to help us reproduce the issue, please send us the following information:

- When I make a simple datatransfere with a ADO NET Destination and the Devart driver it works

1. Describe the steps you perform from creating the package till the moment when the issue occurs;

2. DDL/DML scripts of the table with which the issue is reproduced;

3. Please also describe the steps you perform when using the Devart MySql Destination component if they differ from the ones used in the first step.

[iznogood]

Hi

Table definition:
MySQL:
CREATE TABLE nb_sat_replic.`devartbigint` (
`id` int NOT NULL,
`Timestamps` bigint NOT NULL,
`id2` int NOT NULL,
`navn` varchar(45) DEFAULT NULL,
PRIMARY KEY (`id`,`id2`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

MS SQL Server
CREATE TABLE devartbigint (
id int NOT NULL,
Timestamps timestamp NOT NULL,
id2 int NOT NULL,
navn nvarchar(45) DEFAULT NULL,
PRIMARY KEY (id,id2)
)

Then
1. I make a new project
2. I make a data flow task
3. I make a SQL Server source as
SELECT id, CAST(Timestamps AS BIGINT) AS Timestamps, id2, navn FROM devartbigint
4. I make af Devart MySql Connection Manager
5. I make af Devart MySql Destination
6. I open the Advanced Editor for Devart MySql Destination
7. In Connection Manager I choose the Devart connection manager from 4.
8. In Component Properties, I choose devartbigint as TableName.
9. When I click Column Mappings, I get the error: The number of input columns for devart MySql Destination.Inputs[input] cannot be zero.
10. Pressing Refresh
11. I get an error: System.ArgumentException: Value dos not fall within the expected range.

Looking at the tables in the gui the column "navn" is NOT in the destination.

[Pinturiccio]

We have reproduced the issue. We will investigate it and post here about the results as soon as possible.

[Pinturiccio]

We have fixed the bug with columns mapping in the SSIS DataFlow Destination component when table has a composite primary key. We will post here when the corresponding build of dotConnect for MySQL is available for download.

[Pinturiccio]

New build of dotConnect for MySQL 8.3.239 is available for download now!
It can be downloaded from http://www.devart.com/dotconnect/mysql/download.html (trial version) or from Registered Users' Area (for users with valid subscription only).
For more information, please refer to http://forums.devart.com/viewtopic.php?t=30326