[TF Oracle Upsert Destination ] Error: System.Exception: Could not create temporary destination table: Could not add the unique index or primary key index to the destination table because no unique indexes or primary key indexes are defined for 'Tablename'
- Remove the temporary (“temp”) table from the Oracle Database which was created upon execution failure within the SSIS Package.
When an error occurs after a temp table is created, Oracle will retain that temp table value until it is removed by the user. This prevents further temp table creation until the temporary table is removed within Oracle.
- After a failure has occurred, open the Oracle Database and locate the temp table created.
The temp table created by the Upsert Destination contain the name of the actual destination table within them. The temp table will also begin with the following characters: “TMPUPS_”. Below is a screenshot of sample temp tables created by failed packages.
- Right click on the temp table, go to “Table” and then select the option to “Drop”. A new window will open titled, “Drop”. Within this window, check “Purge” and then hit “Apply”.
- A Confirmation box will appear advising that the temp table has been dropped. Select “OK”.
The temp tables have now been removed and execution of the package can once again take place.