{"product_id":"9780768687279","title":"Microsoft SQL Server 2008 Integration Services Unleashed","description":"\u003cp\u003eMicrosoft SQL Server Integration Services is Microsoft’s powerful platform for building enterprise-level data integration and data transformation solutions. It’s a powerful product, but it’s also complex and can be confusing if you don’t have a clear map for the journey. \u003ci\u003eMicrosoft SQL Server 2008 Integration Services Unleashed\u003c\/i\u003e will be the only book you’ll need to harness the power that Integration Services provides.\u003c\/p\u003e  \u003cp\u003e \u003c\/p\u003e  \u003cp\u003eThrough clear, concise explanations and samples, you’ll grasp a clear understanding of working in the Integration Services environment, including how to set up stock components, how to use the various designer features, and how to gain practical knowledge on configuring, deploying, securing, and managing packages. Sample packages are provided to reinforce the discussion and quickly help you gain hands-on experience, and more complex topics such as Data Flow Task internals and tuning, advanced transformations, and writing custom components are all illustrated in easy-to-understand graphics. In addition, there are several custom tasks and transformations and two useful utilities with full source code available for you to use and study, including an ADO.NET destination, a text file encryption task, and a data profiling transform.\u003c\/p\u003e  \u003cp\u003e \u003c\/p\u003e  \u003cp\u003eDetailed information on:\u003c\/p\u003e  \u003cul\u003e  \u003cli\u003eUsing the powerful Integration Services tools to create solutions without the need to write lines of code   \u003c\/li\u003e\n\u003cli\u003eCreating packages programmatically or developing custom tasks via the Integration Services object   \u003c\/li\u003e\n\u003cli\u003eBuilding robust packages to solve common requirements   \u003c\/li\u003e\n\u003cli\u003eSecuring packages for different environments   \u003c\/li\u003e\n\u003cli\u003eUsing often overlooked or unknown platform features   \u003c\/li\u003e\n\u003cli\u003eSetting up all the stock components, including data flow components, tasks, Foreach enumerators, connection managers, and log providers   \u003c\/li\u003e\n\u003cli\u003eWriting robust and useful custom tasks   \u003c\/li\u003e\n\u003cli\u003eBuilding packages that seamlessly deploy to other environments   \u003c\/li\u003e\n\u003cli\u003eWriting custom data flow adapters and transforms   \u003c\/li\u003e\n\u003cli\u003eUsing script tasks and components   \u003c\/li\u003e\n\u003cli\u003eEasily modifying configurations for multiple packages simultaneously   \u003c\/li\u003e\n\u003cli\u003eWriting a Task UI that looks just like the stock tasks   \u003c\/li\u003e\n\u003cli\u003eTapping into the power of Integration Services for accessing heterogeneous data sources   \u003c\/li\u003e\n\u003cli\u003eUsing expressions to make packages more responsive to the environment   \u003c\/li\u003e\n\u003cli\u003eMigrating your DTS packages with no stress\u003c\/li\u003e \u003c\/ul\u003e  \u003cp\u003e \u003c\/p\u003e  \u003cp\u003eKirk Haselden is the Group Program Manager for the Microsoft Master Data Management product forthcoming in the next wave of Office SharePoint Services and owns the long term strategy, vision, planning, and development of that product. Kirk has been with Microsoft for 12 years in various groups including Hardware, eHome, Connected Home, SQL Server, and Office Business Platform. He was the development manager for Integration Services and the primary designer for the runtime, as well as many of the tasks. He has written a number of articles for SQL Server Magazine, speaks regularly at industry events, writes profusely on his personal and MSDN blog, and holds 35 patents or patents pending.\u003c\/p\u003e  \u003cp\u003e \u003c\/p\u003e  \u003cp\u003eCategory: Microsoft SQL Server\u003c\/p\u003e  \u003cp\u003eCovers: Microsoft SQL Server 2008 Integration Services\u003c\/p\u003e  \u003cp\u003eUser Level: Intermediate–Advanced\u003c\/p\u003e","brand":"Pearson Education","offers":[{"title":"Default Title","offer_id":47122213306608,"sku":"9780768687279","price":47.99,"currency_code":"USD","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0737\/7593\/9824\/files\/9780768687279_p0.jpg?v=1763661358","url":"https:\/\/shop-qa.barnesandnoble.com\/products\/9780768687279","provider":"Barnes \u0026 Noble (DEV)","version":"1.0","type":"link"}