Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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] [
What if you try to insert the same record manually from outside your job?
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.