Using SSIS to move data from Interbase to SQL. Originating table in Interbase has a Primary Key, but I did not put the PK on the destination table (for the record: PK is an int, and is unique in the table)
When I attempt to run the package, it fails with a message about violating the PK constraint... which makes no sense to me when the destination table has neither PK nor identity.
I am using an ODBC connection, ado .net source with oledb destination.
Anyone encountered this before?
Thanks!