Hands-On Microsoft SQL Server 2008 Integration Services part 11. Deploy and manage high-performance data transformation solutions across your enterprise using the step-by-step techniques in this fully revised guide. Hands-On Microsoft SQL Server 2008 Integration Services, Second Edition explains the tools and methods necessary to extract conclusive business intelligence from disparate corporate data. Learn how to build and secure packages, load and cleanse data, establish workflow, and optimize performance. Real-world examples, detailed illustrations, and hands-on exercises are included throughout this practical resource. . | 78 Hands-On Microsoft SQL Server 2008 Integration Services the FileUsageType property of the connection manager to indicate how you want to use the File Connection Manager that is you want to create or use an existing file or a folder. Flat File Connection Manager This connection manager provides access to data in a flat file. It is used to extract data from a flat-file source or load data to a destination and can use delimited fixed-width or ragged-right format. This connection manager accesses only one file. If you want to reference multiple flat files you must use a Multiple Flat Files Connection Manager. FTP Connection Manager Use this connection manager whenever you want to upload or download files using File Transfer Protocol FTP . It enables you to connect to an FTP server using anonymous authentication or basic authentication. The default port used for FTP connection is 21. FTP Connection Manager can send and receive files using active or passive mode. The transfer mode is defined as active mode when the server initiates the FTP connection and passive mode when the client initiates the FTP connection. HTTP Connection Manager Whenever you want to upload or download files using HTTP port 80 use this connection manager. It enables you to connect to a web server using HTTP. The Web Service task provided in Integration Services uses this connection manager. Like the FTP Connection Manager the HTTP Connection Manager allows connections using anonymous authentication or basic authentication. MSMQ Connection Manager When you re working with mainframe systems or on systems with messaging architecture you will need to use Message Queuing within your packages for which you will have to use an MSMQConnection Manager. For example if you want to use the Message Queue task in Integration Services you need to add an MSMQConnection Manager. An MSMQ_Connection Manager enables a package to connect to a message queue. Analysis Services Connection Manager If you are creating an
