Hands-On Microsoft SQL Server 2008 Integration Services part 4. 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. . | 8 Hands-On Microsoft SQL Server 2008 Integration Services Depending on where the packages have been deployed access control methods are provided by the underlying platform. For example you can control access to packages saved into SQL Server using SQL Server roles for Integration Services while Windows access control mechanisms are used if the packages are deployed to the file system. Integration Services packages can use various levels of encryption to protect sensitive information such as passwords and connection strings. You can also digitally sign your SSIS packages to establish the authenticity of the packages. Chapter 7 covers these security features in detail. Service-Oriented Architecture SSIS provides support for Service-Oriented Architecture SOA through a combination of HTTP connection manager Web Service task and XML source. These can be used together to pull XML data from URLs into the data flow. SSIS Package as a Data Source SSIS provides a DataReader destination that enables a SSIS package to be used as a data source. When you use a DataReader destination in your SSIS package you effectively convert your SSIS package into an on-demand data source that can provide integrated transformed and cleansed data from multiple data sources to an external application such as SQL Server Reporting Services. You can also use this feature to connect to multiple web services extract RSS feeds and combine and identify interesting articles to be fed back to the application on demand. This is a very unique and powerful feature that places SSIS far ahead of other traditional ETL tools. Programmability SSIS provides a rich set of APIs in a native and managed form that enables you not only to extend the functionality provided by preconfigured components but also to develop new custom components using C or other languages supported by the .NET Framework such as Visual C Visual Basic 2008 . With the provision of this functionality you can include your already-developed .
