MERGE INTO dbo.Dim_Account AS tgt USING #TempSCD AS src ON tgt.AccountKey = src.AccountKey AND tgt.IsCurrent = 1 WHEN MATCHED AND src.IsChanged = 1 THEN UPDATE SET tgt.IsCurrent = 0, tgt.EndDate = @LoadDate WHEN NOT MATCHED BY TARGET THEN INSERT (AccountKey, AccountName, ..., IsCurrent, StartDate, EndDate) VALUES (src.AccountKey, src.AccountName, ..., 1, @LoadDate, '9999-12-31');
All (SQL Server, Text File, Windows Event Log) are enabled in the SSIS Catalog . The video emphasizes configuring LoggingMode = Detailed for the Data Flow component to capture row‑level statistics (rows read, rows written, rows rejected).
The built‑in enumerator is memory‑efficient , runs entirely within the SSIS engine, and automatically respects transactional boundaries set on the container.
MERGE INTO dbo.Dim_Account AS tgt USING #TempSCD AS src ON tgt.AccountKey = src.AccountKey AND tgt.IsCurrent = 1 WHEN MATCHED AND src.IsChanged = 1 THEN UPDATE SET tgt.IsCurrent = 0, tgt.EndDate = @LoadDate WHEN NOT MATCHED BY TARGET THEN INSERT (AccountKey, AccountName, ..., IsCurrent, StartDate, EndDate) VALUES (src.AccountKey, src.AccountName, ..., 1, @LoadDate, '9999-12-31');
All (SQL Server, Text File, Windows Event Log) are enabled in the SSIS Catalog . The video emphasizes configuring LoggingMode = Detailed for the Data Flow component to capture row‑level statistics (rows read, rows written, rows rejected). SSIS-951.mp4
The built‑in enumerator is memory‑efficient , runs entirely within the SSIS engine, and automatically respects transactional boundaries set on the container. MERGE INTO dbo
© 2000-2023 Javier Bezos • www.texnia.com • jbezos.github.io