Working on a simple SSIS Package that basically uses the “Conversion” Data Flow Transformation toolset to copy unicode data to a non-unicode destination.
To speed lab work, decided to use the AdventureWorks’s Production.Product table.
As anyone familiar with that table knows, the primary key (ProductID) is an identity column and so it system populated and does not lend itself to straightforward population.
The exact error message we were getting is:
Error 1 -Validation error. Data Flow Task: Data Flow Task: Failure inserting into the read-only column “ProductID”. Package.dtsx 0 0
Crediting Rafael Salas; he blogs here.
Marking ‘Keep identity’ option (when using fast load as data access mode) in the OLE DB destination component should work.