<div>
<div class="content wysiwyg-content">
Hi,<br />
Currently working on an SSIS ETL package. A Slowly Changing Dimension is configured as a Type 1 with one of the columns as a fixed attribute. I have set the package to continue when it detects changes to the fixed attribute and I would like to capture the data when this occurs. How could I capture this data?<br />
Any help would be appreciated.<br />
Thanks
</div>
</div>


Hi,
Currently working on an SSIS ETL package. A Slowly Changing Dimension is configured as a Type 1 with one of the columns as a fixed attribute. I have set the package to continue when it detects changes to the fixed attribute and I would like to capture the data when this occurs. How could I capture this data?
Any help would be appreciated.
Thanks

Capture data on change of fixed attribute

SQL Server Integration Services (SSIS) is a component of the Microsoft SQL Server database software that can be used to perform a broad range of data migration tasks. SSIS is a platform for data integration and workflow applications. It features a fast and flexible data warehousing tool used for data extraction, transformation, and loading (ETL). The tool may also be used to automate maintenance of SQL Server databases and updates to multidimensional cube data. SSIS replaced Data Transformation Services, which had been a feature of SQL Server since Version 7.0.