Microsoft® SQL Server® 2012 Bible

1178

Part IX: Business Intelligence

Source Defi nition

XML Reads a simple XML fi le and presents it to the data fl ow as a table, using either

an inline schema (a header in the XML fi le that describes the column names and

data types) or an XSD (XML Schema Defi nition) fi le. The XML source does not use

a connection manager; instead, specify the input fi lename and then either spec-

ify an XSD fi le or indicate that the fi le contains an inline schema.

Script A script component can act as a source, destination, or transformation of a data

fl ow. Use a script as a source to generate test data or to format a complex exter-

nal source of data. Search for the topic “Extending the Data Flow with the Script

Component” in SQL Server Books Online for full code samples and related

information.

Understanding SSIS Destinations

Data Flow destinations provide a place to write the data transformed by the Data Flow

task. Confi guring destinations is similar to confi guring sources, including both basic and

advanced editors, and the three common steps:

■ Connection Manager: Specify the particular table, fi les, view, or query to which

data will be written.

■ Columns: Map the columns from the data fl ow (input) to the appropriate destina-

tion columns.

■ Error Output: Specify what to do should a row fail to insert into the destination:

Ignore the row, cause the component to fail (default), or redirect the problem row to

error output.

Table 52-3 outlines available Data Flow Destinations.

TABLE 52-3 Data Flow Destinations

Destination Defi nition

ADO Net Uses an ADO.NET connection manager to write data to a selected table or

view.

New since R2, ADO.NET destinations now has option Use Bulk Insert When

Possible, which mimics the OLE DB fast load.

DataReader Makes the data fl ow available via an ADO.NET DataReader, which can be

opened by other applications, notably Reporting Services, to read the output

from the package.

Dimension

Processing

Enables the population of Analysis Services dimensions without fi rst populat-

ing the underlying relational data source.

Identify the Analysis Services connection manager of interest, choose the

desired dimension, and then select a processing mode.

TABLE 52-2 (continued)

c52.indd 1178c52.indd 1178 7/31/2012 10:29:29 AM7/31/2012 10:29:29 AM

http://www.it-ebooks.info