Database Reference
In-Depth Information
Now that you better understand the query and the expected output, let's return to
your package. Click Parse Query to ensure you do not have any errors in your syntax,
and then click Preview to see a sample of the results. Click the Columns page to ensure
that the column list has been successfully updated; then click OK to return to the Data
Flow designer.
You should now see an error in your data flow, as illustrated in Figure 1-19 . This is
expected because you've changed the columns that your data source is providing, but
your destination still expects the old column list.
Figure 1-19 . The completed data flow task
Before you can fix this error, you need to return to SSMS to create a table to store
this data. Create this table now using the code in Listing 1-8 .
Listing 1-8 . T-SQL Code to Create the dba_monitor_unusedIndexes Table
USE dbaCentralLogging;
GO
CREATE TABLE dbo.dba_monitor_unusedIndexes
(
log_id
INT IDENTITY(1,1)
,captureDate
DATETIME
,serverName
NVARCHAR(128)
,schemaName
SYSNAME
,databaseName
SYSNAME
 
 
 
 
Search WWH ::




Custom Search