Dictionary error in ADF

Hari 26

Trying to copy data from SQL server to Snowflake (new connection) and it fails with the below error.

'Type=System.Collections.Generic.KeyNotFoundException,Message=The given key was not present in the dictionary.,Source=mscorlib,'

With Snowflake legacy connection the copy function is working fine. Source and destination is same, except that it used legacy snowflake connection.

Bhargava-MSFT 29,266 Reputation points Microsoft Employee

2024-06-04T23:13:35.8866667+00:00

Hello Hari,

Are you using SHIR here? if yes, please make sure to update the SHIR version to the latest version?
Hari 26 Reputation points

2024-06-07T19:10:52.7433333+00:00

We are not using SHIR.
Bhargava-MSFT 29,266 Reputation points Microsoft Employee

2024-06-07T23:59:34.8933333+00:00

Thanks for the confirmation Hari

Can you check if you are using the datatype 'bigint' in the source? if yes, this needs to be converted as a string.

in case if you are not willing to change the source, then you can use the dataflow to convert the datatype to string.

I hope this helps.
Bhargava-MSFT 29,266 Reputation points Microsoft Employee

2024-06-11T20:40:22.1166667+00:00

Hello Hari,

I am checking in to see if you had a chance to look into my above response.
Hari 26 Reputation points

2024-06-11T22:26:39.9566667+00:00

We are not using 'bigint', the table has string, double and datetime datatypes.

Thanks, Hari

1 answer