Knight's Microsoft SQL Server 2012 Integration Services 24-Hour Trainer
Devin Knight, Mike Davis
Format: PDF / Kindle (mobi) / ePub
Book-and-video package gets novices up to speed on Microsoft SQL Server 2012
If you need a practical, hands-on introduction, especially to SQL Server Integration Services (SSIS), this book-and-video package from authority Brian Knight is the perfect solution. Each lesson includes three major components: a description of how each SSIS feature or process works, a tutorial that walks you through the process or technique, and an accompanying video lesson. It's a complete learning package that will give you the confidence you need to start your first SSIS project.
- Guides novice database administrators and developers who are learning Microsoft SQL Server 2012 and SQL Server Integration Services (SSIS)
- Provides expert instruction from leading SQL Server authority and author, Brian Knight
- Includes a book and a video, complete instruction that includes lessons, hands-on tutorials, and video demonstrations by the author
- Covers the very latest changes and updates in the SQL Server 2012 release
Microsoft SQL Server 2012 Integration Services 24-Hour Trainer makes SQL Server 2012 and SSIS much less intimidating.
Note: CD-ROM/DVD and other supplementary materials are not included as part of the e-book file, but are available for download after purchase.
ignore. Please select Lesson 1 on the DVD, or online at www.wrox.com/go/ssis2012video, to view the video that accompanies this lesson. 2 Installing SQL Server Integration Services This book requires that you have SQL Server Data Tools (SSDT) and the SQL Server Integration Services (SSIS) service installed. To develop SSIS, you cannot use SQL Express. The SSIS run time to run packages does ship with all editions, but on some of the lower editions that run time may not work with all SSIS
much easier than writing any program. In this lesson, you learn how to create your first SSIS package. Granted, the package does very little here, but it shows you many of the concepts that will be critical throughout the rest of the book. Many of the concepts may not make complete sense yet when it comes to configuring various components, but no worries—the concepts are deeply covered throughout the rest of the book. To create your first package, you need an SSIS project. Creating a project is
The advice and strategies contained herein may not be suitable for every situation. This work is sold with the understanding that the publisher is not engaged in rendering legal, accounting, or other professional services. If professional assistance is required, the services of a competent professional person should be sought. Neither the publisher nor the author shall be liable for damages arising herefrom. The fact that an organization or Web site is referred to in this work as a citation
query. The SQL query can handle multiple parameters. In this screen, as shown in Figure 12-3, you can create the parameter mappings to connect the parameter in the SQL command to a package variable. You see an example of parameters later in this lesson. 82 ❘ SECTION 2 CONTROL FLOW Figure 12-3 You can use the Execute SQL Task to count data in a table and return a number for the result set. If the count is returned as an alias, you can name the result set. For example, if the SQL query
those files into a database. There is no built-in compression task in the SSIS Toolbox. The Execute Process Task enables you to call these windows or console applications. Errors that occur in the outside programs can be captured in the SSIS package in a variable. This variable value can be written to a log file or a table for auditing. The Execute Process Task is shown in Figure 13-1, where the Process node is selected on the left. In this screen, you select the executable the task will call and