Was this page helpful?
Additional feedback?
1500 characters remaining
Export (0) Print
Expand All

Select a Dimension Table and Keys (Slowly Changing Dimension Wizard)

Topic Status: Some information in this topic is preview and subject to change in future releases. Preview information describes new features or changes to existing features in Microsoft SQL Server 2016 Community Technology Preview 2 (CTP2).

Use the Select a Dimension Table and Keys page to select a dimension table to load. Map columns from the data flow to the columns that will be loaded.

To learn more about this wizard, see Slowly Changing Dimension Transformation.

Connection manager

Select an existing OLE DB connection manager from the list, or click New to create an OLE DB connection manager.

Note Note

The Slowly Changing Dimension Wizard only supports OLE DB connection managers, and only supports connections to SQL Server.


Use the Configure OLE DB Connection Manager dialog box to select an existing connection manager, or click New to create a new OLE DB connection.

Table or View

Select a table or view from the list.

Input Columns

Select from the list of input columns for which you may specify mapping.

Dimension Columns

View all available dimension columns.

Key Type

Select one of the dimension columns to be the business key. You must have one business key.

Was this page helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

© 2015 Microsoft