1171
Chapter 52: Building, Deploying, and Managing ETL Workfl ows in Integration Services
52
■ (^) Analysis Services Execute DDL: Sends Analysis Services Scripting Language (ASSL)
scripts to an Analysis Services server to create, alter, or process cube and data min-
ing structures.
■ Analysis Services Processing: Identifi es an Analysis Services database, a list of
objects to process, and processing options.
■ Bulk Insert: Provides the fastest mechanism to load a fl at fi le into a database
table without transformations. Similar to the BCP function of SQL. Specify source
fi le and destination table as a minimum confi guration. If the source fi le is a simple
delimited fi le, then specify the appropriate row and column delimiters; otherwise,
create and specify a format fi le that describes the layout of the source fi le.
■ (^) CDC Control: Provides a comprehensive set of options for using Change Data
Capture enabled tables in your SSIS packages. For more on using, see “CDC in SSIS
for SQL Server 2012” at http://www.mattmasson.com/index.php/2011/12/cdc-in-
ssis-for-sql-server-2012-2/?utm_source=rss&utmmedium=rss&utm
campaign=cdc-in-ssis-for-sql-server-2012-2
■ Data Flow: Provides a fl exible structure for loading, transforming, and storing data
as confi gured on the Data Flow tab. See the section “Using Data Flow Components,”
later in this chapter for the components that you can confi gure in a Data Flow task.
The Data Flow task represents the highest impact change between DTS and SSIS.
■ Data Profi ling: Builds an XML fi le to contain an analysis of selected tables.
Available analyses include null ratio, column length for string columns, statistics
for numeric columns, value distribution, candidate keys, and inter-column depen-
dencies. Open the resulting fi le in the Data Profi le Viewer to explore the results.
Alternatively, the analysis results can be sent to an XML variable for programmatic
inspection as part of a data validation regimen.
■ Data Mining Query: Runs prediction queries against existing, trained data mining
models.
■ Execute Package: Executes the specifi ed Integration Services package, enabling
packages to perform smaller tasks, all controlled by parent packages in the Package
Deployment Model, or by Entry point packages in the Project Deployment Model.
Execute Package tasks now can choose between referring to an external source (File
Connection Manager) or Project References (Parameters) depending on the mode of
deployment model. Execute Package tasks using the Project Reference type can set
the values of Package Parameters, but cannot set the values of Project Parameters.
■ (^) Execute Process: Executes an external program or batch fi le, including PowerShell
scripts. Specify the program to be run in the Executable property, including
the extension (for example, MyApp.exe), and the full path if the program is not
included in the computer’s PATH setting (for example, C:\stuff\MyApp.exe).
■ (^) Execute SQL: Runs a SQL script or query, optionally returning results into
variables. On the General page of the editor, set the ConnectionType and
c52.indd 1171c52.indd 1171 7/31/2012 10:29:28 AM7/31/2012 10:29:28 AM
http://www.it-ebooks.info