Chapter 3. Migrating from DTS

IN THIS CHAPTER

The Scope of Things

Available Migration Resources

Some Migration Considerations

“WHAT HAVE YOU DONE WITH MYDTS?!”—DARREN GREEN

The Scope of Things

When presenting Integration Services (IS) to current or former Data Transformation Services (DTS) users, one of the first things they want to know is how Integration Services will affect their current packages. The questions come in different forms, such as the following: Will it break my current packages? Can I run IS side by side with DTS? Can I continue to use my DTS packages while building new IS packages? or Can I upgrade my DTS packages to IS packages? But, essentially, what people are asking is, “What’s the migration story?”

Caution

If you ...

Get Microsoft SQL Server 2005 Integration Services now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.