Given key was not present in the dictionary error

Symptom
During Data Migration using SSMA, tables may get an error “The given key was not present in the dictionary”

Cause
‘The given key was not present in the dictionary’ usually occur when the schema of the table in sql server doesn’t exactly match with that of oracle database.

Resolution
The error message ‘The given key was not present in the dictionary’ usually occur when the schema of the table in sql server doesn’t exactly match with that of oracle database.
There might be lot of reasons related with this:

- Tables have different column names(column names(case sensitive) should match both on oracle and sql server)

- Natural column order- the order of columns as the server(oracle or sql server)

- Data types

More Information
Article Id: KBO2SS1008

Applies to
SSMA 2005 for Oracle
SSMA 2008 for Oracle