Ssis-668 !!top!! -

: CALL SYSPROC.ADMIN_CMD('REORG TABLE your_table_name')

CREATE TABLE dbo.stg_Customer ( SurrogateKey BIGINT IDENTITY(1,1) PRIMARY KEY, CustomerKey INT NOT NULL, -- Business key from source Name NVARCHAR(200), Email NVARCHAR(200), Address NVARCHAR(400), EffectiveFrom DATETIME2 NOT NULL, EffectiveTo DATETIME2 NULL, IsCurrent BIT NOT NULL DEFAULT (1), LoadDateTime DATETIME2 NOT NULL DEFAULT (SYSUTCDATETIME()) ); GO -- Indexes for fast MERGE CREATE CLUSTERED INDEX IX_stg_Customer_Key ON dbo.stg_Customer (CustomerKey); SSIS-668

To resolve SSIS-668, the following steps were taken: : CALL SYSPROC

Running a localized instance to stress-test the protocol against existing legacy systems. 1) PRIMARY KEY

The primary digital distributor for S1 content.