May 2007
Intermediate to advanced
432 pages
11h 43m
English
Content preview from Expert 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.
8.1. Working with a Team in SSIS
As you can imagine, in most companies, there isn't just a single person developing SSIS packages for a single project. Generally, for most medium and large companies, there would be a few people developing the project's ETL, and they would need to collaborate on the solution. Because of this, source control becomes mandatory for keeping one developer from coding on a package that another developer is already working on. Another tactic is to break large packages into smaller, more modular packages to allow for multiple components to be worked on at the same time. Additionally, package templates can create consistency between the developers.
8.1.1. Source Control Integration
A key ingredient to a stable development environment is going to be source control. Source control ensures that only a single developer can work on a package at any given point in time, and, if a problem occurs, you can roll back code to a previous version. The great thing about the SSIS development environment in BIDS is that it can take advantage of the Visual Studio 2005 source-control integration. One of the most popular source control systems is Visual Source Safe (VSS). In this section, you'll see how easy it is to integrate your SSIS project into Source Safe 2005. You can also use Visual Studio Team Systems, a concept that is covered in the book Professional SQL Server 2005 Integration Services (Wiley Publications, 2006).
First, however, a word of caution about source ...
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.