Microsoft KB Archive Search

Notice: This website is an unofficial Microsoft Knowledge Base (hereinafter KB) archive and is intended to provide a reliable access to deleted content from Microsoft KB. All KB articles are owned by Microsoft Corporation. Read full disclaimer for more details.

  1. Home
  2. "The given key was not present in the dictionary" error message when using SSMA for Oracle

"The given key was not present in the dictionary" error message when using SSMA for Oracle

Symptoms

When using SQL Server Migration Assistant for Oracle, you may get the following error message

The given key was not present in the dictionary.

↑ Back to the top

Cause

The error message usually occurs when the schema of the table in SQL Server does not match the schema of the source database. Some examples include tables having columns with different names, the order of the columns being different, data types being different etc.

↑ Back to the top

Resolution

Ensure that the schema of the SQL Server table matches that of the source database before performing the migration activity.

↑ Back to the top

More Information

 

 

↑ Back to the top

Keywords: vkball, kb

↑ Back to the top

Article Info
Article ID : 2020724
Revision : 1
Created on : 1/8/2017
Published on : 10/4/2010
Exists online : False
Views : 132