select-a-dimension-table-and-keys-slowly-changing-dimension-wizard.md

title	description	author	ms.author	ms.date	ms.service	ms.subservice	ms.topic	f1_keywords
Select a Dimension Table and Keys (Slowly Changing Dimension Wizard)	Select a Dimension Table and Keys (Slowly Changing Dimension Wizard)	chugugrace	chugu	03/14/2017	sql	integration-services	conceptual	sql13.dts.loaddimwizard.selecttableandkeys.f1

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

[!INCLUDEsqlserver-ssis]

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.

Options

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

Note

The Slowly Changing Dimension Wizard only supports OLE DB connection managers, and only supports connections to [!INCLUDEssNoVersion].

New
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.

See Also

Configure Outputs Using the Slowly Changing Dimension Wizard