When looking at the different components that are available in SQL Server 2008 R2 Integration Server you will see that the list is very long.
A short overview of the most important components available in this release are :
- Source & Destination: Standard SQL Server 2008 R2 Integration Services comes with a limited set of sources and destinations. But this set can be extended by installing additional providers, or by creating ODBC connections. This makes it possible to almost load from any source available.
- Look up: One of the functions that are performed most during ETL is the look up in another table/view. Not only to validate the existence of a value in the reference table, but also to retrieve a key to create a relationship with that table. With SQL Server 2008 R2 Integration Services the look up component can do this in memory. It will cache the information once and this cache can then be reused by all components in the package.
- SCD: "Slowly Changing Dimension" (SCD) is a term that affects mostly the loading of dimension information. Depending on the type of SCD your update strategy will be different. With the SCD component in SQL Server 2008 R2 Integration Services the data flow is created for you depending on the choices you made in the SCD wizard.
Contact us for more information on SQL Server 2008 R2 Integration Services !