topic Re: Big-Data tMSSQLBulkExec Bulk Update returns Identity column 'PK_column' contains invalid INCREMENT in Talend Studio

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

Anonymous — Sat, 16 Nov 2024 08:16:43 GMT

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

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

TRF — Mon, 14 May 2018 09:15:38 GMT

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

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

Anonymous — Tue, 15 May 2018 15:02:39 GMT

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.