January 2006
Beginner to intermediate
720 pages
19h 26m
English
book
Professional SQL Server™ 2005 Integration Services
by Brian Knight, Allan Mitchell, Darren Green, Douglas Hinson, Kathi Kellenberger, Andy Leonard, Erik Veerman, Jason Gerard, Haidong Ji, Mike Murphy
Content preview from Professional SQL Server™ 2005 Integration Services
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,
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.
2.3. Business Intelligence Development Studio
The Business Intelligence Development Studio (BIDS) is where most of your time is spent as a SSIS developer. It is where you create, deploy, and manage your SSIS projects.
BIDS uses a light version of Visual Studio 2005. If you have the full version of Visual Studio 2005 and SQL Server 2005 installed, you can create business intelligence projects there as well in the full interface. Either way, the user experience is the same. In SQL Server 2005, the SSIS development environment is detached from SQL Server, so you can develop your SSIS solution offline and then deploy it to wherever you'd like in a single click. Previously, in SQL Server 2000, you had to connect to a SQL Server instance in Enterprise Manager and then open the DTS Designer to create a package.
BIDS can be seen in the root of the SQL Server program group. Once you start BIDS, you'll be taken to the Start Page. An example of a Start Page is shown in Figure 2-9. You can see that a few windows are already open by default: Solution Explorer, Toolbox, Output, and Class View. You can open more windows (you'll learn about these various windows in a moment) by clicking their corresponding icon in the upper-right corner or under the View menu.
The Start Page contains key information about your BIDS environment, such as the last few projects that you had open under the Recent Projects box. In the Getting Started box, you can click Import and Export settings to import your Visual ...
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.