Microsoft – SQL Server – Integration Service – BIDS – Inserting into Identity Column

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.

Error Message

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.



Leave a Reply

Please log in using one of these methods to post your comment: Logo

You are commenting using your account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )


Connecting to %s