Primary Key Constraint Violation in SSIS with Quotation Mark Using SSIS Data Flow Task to transfer records from table in 1 SQL Server database to an IDENTICAL table in another SQL Server (2012) and getting "Violation of PRIMARY KEY constraint 'FLG_APVN_KEY_0'. Cannot insert duplicate key in object 'dbo.FLG_APVN'. The duplicate key value is ("ARIZ0010   ).".
In the Source table (FLG_APVN), there are two records with the following Primary Key values:   "ARIZ0010    and    ARIZ0010
Obviously similar but definitely distinct. The quotation mark at the beginning of the first PK Value seems to be getting dropped off by SSIS in the insert causing a primary key violation. I need both records in the destination table with their primary keys intact. How do I do this? (SQL Server 2012, SSIS from Visual Studio 2012).
Solved. See Comment above. Turns out that the quotation mark wasn't the problem.