Big-Data tMSSQLBulkExec Bulk Update returns Identity column 'PK_column' contains invalid INCREMENT

[Anonymous]

My previous post was marked/flagged as spam. This is not a spam message. Please do not flag this topic. I am in need of assistance with this issue.

I am working on an ETL Process that inserts new data and updates changed data from a staging table into a dimension table in a SQL Server Database.

I have set up the table in SQL Server so that it looks like this:

CREATE TABLE [schema].[dim_learning_activity](
    [dim_learning_activity_id] [bigint] IDENTITY(1,1) NOT NULL,
    [activity_fk] [bigint] NOT NULL,
    [name] [

To see the whole post, download it here

[TRF]

What if you try to insert the same record manually from outside your job?

[Anonymous]

Yes, an MSSQL query UPDATE table_name SET column = 'value' WHERE dim_learning_activity_id = @var works just fine, and even an MSSQLOutput works with update on key, but not the Bulk Update.