Datasheet

Chapter 1: Welcome to SQL Server Integration Services
4
Where do you find the wizard? It depends. If you just need to perform a quick import or export, access
the wizard directly from the Start menu by navigating to Start
Microsoft SQL Server 2008 Import
and Export Data. The other option is to open up a project in the SSIS development environment and
select the menu option Project SSIS Import and Export Wizard. We cover this in detail in Chapter 2.
Before we get into all the mechanics for that, Figure 1 - 1 shows an example of the wizard fully loaded and
ready to move some data.
Figure 1 - 1
The Business Intelligence Development Studio
The Business Intelligence Development Studio (BIDS) is the central environment that you ’ ll spend most
of your time in as an SSIS developer. BIDS is just a specialized use of the familiar Visual Studio
development environment that can host many different project types from Console applications to Class
Libraries and Windows applications. Although you may see many project types, BIDS actually only
contains project templates for Analysis Services, Integration Services, Report Server, and Report Model
Projects. SSIS in particular uses a business - intelligence project type called an Integration Services project
that provides development design surfaces with a completely ETL - based set of tools in the Toolbox
window. Get your first look at the development environment in Figure 1 - 2.
c01.indd 4c01.indd 4 8/28/08 12:01:15 PM8/28/08 12:01:15 PM