Metadata Collection - SQL Server Integration Services Design Patterns - page 31

,tableName SYSNAME

,indexName SYSNAME

,indexType NVARCHAR(60)

,isFiltered BIT

,isPartitioned BIT

,numberOfRows BIGINT

,userSeeksSinceReboot BIGINT

,userScansSinceReboot BIGINT

,userLookupsSinceReboot BIGINT

,userUpdatesSinceReboot BIGINT

,indexSizeInMB BIGINT

,lastReboot DATETIME

CONSTRAINT PK_dba_monitor_unusedIndexes
PRIMARY KEY NONCLUSTERED(log_id)

);

CREATE CLUSTERED INDEX CIX_dba_monitor_unusedIndexes
ON dbo.dba_monitor_unusedIndexes(captureDate);

Return to Visual Studio and double-click the Central Logging Database icon to edit
its properties. Change the Name of the Table or the View value to
[dbo].[dba_monitor_unusedIndexes], and then click the Mappings page. Because your
source and destination are using the same column names, you can easily update the
mappings by right-clicking in the space between Available Input Columns and Avail-
able Destination Columns and selecting Map Items by Matching Names. Figure 1-20
illustrates this option.