1169
Chapter 52: Building, Deploying, and Managing ETL Workfl ows in Integration Services
52
■ (^) Ragged Right: File data is interpreted using fi xed width for all columns except
the last, which is terminated by the row delimiter.
■ (^) Multiple Flat Files: Same as the Flat File connection manager, but it enables
multiple fi les to be selected, either individually or using wildcards. Data then
appears as a single large table to Integration Services elements.
■ File: Identifi es a fi le or folder in the fi le system without specifying content.
■ (^) Multiple Files: Same as the fi le connection manager, but it enables multiple fi les
to be selected, either individually or using wildcards. This type of connection man-
ager can greatly improve speed.
■ Excel: Identifi es a fi le containing a group of cells that can be interpreted as a table
(0 or 1 header rows, data rows below without row, or column gaps).
Using Other Connection Managers
Beyond Database and File connection managers, several other types are provided:
■ (^) Cache: Defi nes a data cache location. The cache is fi rst populated using the Cache
transform and then used by Lookup transforms within Data Flow tasks. The cache
is a write once, read many data store: All the data to be included in the cache
must be written by a single Cache transform but can then be used by many Lookup
transforms.
■ FTP: Defi nes a connection to an FTP server. This is used with the FTP task to move
and remove fi les or create and remove directories using FTP.
■ HTTP: Defi nes a connection to a web service. Enter the URL of the WSDL (Web
Service Defi nition) for the web service in question — for example, http://
MyServer/reportserver/reportservice.asmx?wsdl points to the WSDL
for Reporting Services on MyServer. Used with the Web Service task to access Web
Service methods.
■ (^) MSMQ: Defi nes a connection to a Microsoft Message Queue; used with a Message
Queue task to send or receive queued messages.
■ (^) SMO: Specifi es the name and authentication method to be used with Database
Transfer tasks (Transfer Objects, Transfer Logins, and so on).
■ (^) SMTP: Specifi es the name of the Simple Mail Transfer Protocol Server for use with
the Send Mail task. Older SMTP server versions may not support all the commands
necessary to send e-mail from Integration Services.
■ WMI: Defi nes a server connection for use with Windows Management
Instrumentation tasks, which enable logged and current event data to be collected.
Using Control Flow Elements
The Control Flow tab provides an environment for defi ning the overall work fl ow of the
package. The control consists of Containers, Tasks, and Precedence Constraints.
c52.indd 1169c52.indd 1169 7/31/2012 10:29:28 AM7/31/2012 10:29:28 AM
http://www.it-ebooks.info