failure inserting into the read-only column

Question

Hi Experts,

I am reading data from src and try to insert the tables in my staging area. i have created in my staging area and i am getting an error. i have attached the error . I am using data conversion org_id data type i kept as eight-byte signed int

CREATE TABLE STORE_MASTER_STG (
ORGANIZATION_ID INT IDENTITY(1,1),
RTL_LOC_ID INT NOT NULL ,
STORE_NAME VARCHAR(255) NULL )

Answer 1

Hi @Sudarsan Pandiyan ,

• We cannot insert values into identity column.
  Identity columns can be used for generating key values. The identity property on a column guarantees the following:
  Each new value is generated based on the current seed & increment.
  Each new value for a particular transaction is different from other concurrent transactions on the table.
• So please ignore the identity column when do the mapping in OLEDB Destination.
  

Best Regards,
Mona

----------

If the answer is helpful, please click "Accept Answer" and upvote it.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.
Hot issues in November--What can I do if my transaction log is full?
Hot issues in November--How to convert Profiler trace into a SQL Server table?