Pluralsight - Integration Services Fundamentals
English | Duration: 7h 0m | WMV3 | 1024x768 | 15fps 289kbps | WMA 128kbps | 771MB
This route explains how to develop Integration Services packages by an emphasis on the development of processes that assist data warehousing. It begins by describing the overall protuberance of package development, then describes the types of tasks that Integration Services and shows in what condition these tasks can be performed sequentially or in similarity in the control flow by using precedence constraints. Then the course continues by reviewing the data flow components that are used in favor of extract, transform, and load processes. In addition, the course covers the Integration Services expression language and scripting, and demonstrates for what reason to debug packages, configure logging, horsemanship transactions, and manage package restarts. It furthermore describes how to automate the completion of packages. The features and demonstrations in this beat focus on the SQL Server 2008 R2 excuse, although most topics also apply to earlier versions of Integration Services.