March 2007
Beginner to intermediate
88 pages
1h 52m
English
Content preview from SQL Server Integration ServicesBecome an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
O’Reilly covers everything we've got, with content to help us build a world-class technology community, upgrade the capabilities and competencies of our teams, and improve overall team performance as well as their engagement.I wanted to learn C and C++, but it didn't click for me until I picked up an O'Reilly book. When I went on the O’Reilly platform, I was astonished to find all the books there, plus live events and sandboxes so you could play around with the technology.I’ve been on the O’Reilly platform for more than eight years. I use a couple of learning platforms, but I'm on O'Reilly more than anybody else. When you're there, you start learning. I'm never disappointed.I'm always learning. So when I got on to O'Reilly, I was like a kid in a candy store. There are playlists. There are answers. There's on-demand training. It's worth its weight in gold, in terms of what it allows me to do.
Example 1: Data Flow
This example walks you through building a simple SSIS package that extracts data from the Sales.SalesOrderHeader table in the AdventureWorks database and writes it to a flat file.
Create an SSIS Project
First we need to create a new SSIS project. An SSIS project is a container used to manage one or more SSIS packages. Follow these steps:
Launch Business Intelligence Development Studio by selecting All Programs → Microsoft SQL Server 2005 → SQL Server Business Intelligence Development Studio from the Start menu.
Select File → New → Project... from the main menu to open the New Project dialog.
Specify Business Intelligence Projects as the project type, select the Integration Services Project template, name the project SSIS Shortcut, and specify its location (or accept the default location). The completed New Project dialog is shown in the following figure.
Figure 5. New Project Dialog
Press the OK button to create the new project and dismiss the New Project dialog. A designer for the new package is created in Business Intelligence Development Studio as shown in the following figure.
Figure 6. New package designer
Right-click the package name Package.dtsx in the Solution Explorer pane and select Rename from the context menu. Change the name to Example1.dtsx. This will display ...
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Read now
Unlock full access
More than 5,000 organizations count on O’Reilly
O’Reilly covers everything we've got, with content to help us build a world-class technology community, upgrade the capabilities and competencies of our teams, and improve overall team performance as well as their engagement.Julian F.
I wanted to learn C and C++, but it didn't click for me until I picked up an O'Reilly book. When I went on the O’Reilly platform, I was astonished to find all the books there, plus live events and sandboxes so you could play around with the technology.Addison B.
I’ve been on the O’Reilly platform for more than eight years. I use a couple of learning platforms, but I'm on O'Reilly more than anybody else. When you're there, you start learning. I'm never disappointed.Amir M.
I'm always learning. So when I got on to O'Reilly, I was like a kid in a candy store. There are playlists. There are answers. There's on-demand training. It's worth its weight in gold, in terms of what it allows me to do.