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

 

Fix

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.
Link

 

 

Leave a Reply

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

WordPress.com Logo

You are commenting using your WordPress.com 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 )

Google+ photo

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

Connecting to %s