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
Problem with bigint and Devart MySql Destination and SSIS
-
- Devart Team
- Posts: 2420
- Joined: Wed 02 Nov 2011 09:44
Re: Problem with bigint and Devart MySql Destination and SSIS
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:
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.
In order to help us reproduce the issue, please send us the following information:
1. Describe the steps you perform from creating the package till the moment when the issue occurs;iznogood wrote:- When I make a simple datatransfere with a ADO NET Destination and the Devart driver it works
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.
Re: Problem with bigint and Devart MySql Destination and SSIS
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.
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.
-
- Devart Team
- Posts: 2420
- Joined: Wed 02 Nov 2011 09:44
Re: Problem with bigint and Devart MySql Destination and SSIS
We have reproduced the issue. We will investigate it and post here about the results as soon as possible.
-
- Devart Team
- Posts: 2420
- Joined: Wed 02 Nov 2011 09:44
Re: Problem with bigint and Devart MySql Destination and SSIS
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.
-
- Devart Team
- Posts: 2420
- Joined: Wed 02 Nov 2011 09:44
Re: Problem with bigint and Devart MySql Destination and SSIS
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
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