Community

Handling Slowly Changing Dimensions in SQL Server Integration Services (SSIS) Packages

by SSWUG Research

(Ray Barley) We have experimented with the Slowly Changing Dimension (SCD) Data Flow Transformation that is available in the SSIS designer and have found a few issues with it. Our major concern is the use of the OLE DB Command Data Flow Transformation for all updates (inferred, type 1 and type 2) t

Read More - Register for Free Membership

Tags:
Author: SSWUG ResearchSSWUG Research is the team that brings you SSWUG-based content and community links. Have an idea? Send us a note at sswugresearch@bitsonthewire.com - we'd love to hear from you.