Knight's Microsoft SQL Server 2012 Integration Services 24-Hour Trainer

Section 1

Installation and Getting Started

• Lesson 1: Moving Data with the Import and Export Wizard
• Lesson 2: Installing SQL Server Integration Services
• Lesson 3: Installing the Sample Databases
• Lesson 4: Creating a Solution and Project
• Lesson 5: Exploring SQL Server Data Tools
• Lesson 6: Creating Your First Package
• Lesson 7: Upgrading Packages to SQL Server 2012
• Lesson 8: Upgrading to the Project Deployment Model

Chapter 1

Moving Data with the Import and Export Wizard

The Import and Export Wizard is the easiest method to move data from sources like Excel, Oracle, DB2, SQL Server, and text files to nearly any destination. This wizard uses SSIS as a framework and can optionally save a package as its output prior to executing. The package it produces will not be the most elegant, but it can take a lot of the grunt work out of package development and provide the building blocks that are necessary for you to build the remainder of the package. Oftentimes as an SSIS developer, you’ll want to relegate the grunt work and heavy lifting to the wizard and do the more complex coding yourself. The wizard does no transformations or cleansing, but instead only moves data from point A to point B.

As with most SQL Server wizards, you have numerous ways to open the tool:

• To open the Import and Export Wizard, right-click the database you want to import data from or export data to SQL Server Management Studio and select Tasks > Import Data (or Export Data based on what task you’re performing). ...