Video:
Pt. 1 - An In-Depth Case Study of Migrating a DTS Package to SSIS
-
Skill level:
300 (Intermediate)
-
Run Time:
12:08
-
Instructor:
Scott Whigham
Description:
This is the first video in our section on migrating a DTS package to SSIS package. If you're looking for an exhaustive treatment of how to migrate a complex DTS package to SSIS, then you definitely will want to watch this section of videos. This section takes an interesting DTS package - iterating through each file returned from a result set, downloading that file via FTP, and then inserting that text file's data in a SQL Server table - and lets you see exactly how to migrate this package to SSIS.
Highlights from this video:
- Using the Package Migration Wizard (PMW)
- Limitations of the PMW
- What to Do When the PMW Reports Success But Your SSIS Packages Fail
- Should You Rewrite Your DTS Package or Use the PMW?
and much more
Download
and watch this video
NOTE: You will need the TSCC codec
installed to view video
Scott Whigham
Scott Whigham is the founder of LearnItFirst.com, one of the web's most extensive
video training libraries focusing on technical training. Scott is also an experienced
consultant, trainer, and author with more than a decade of hands-on experience working
with SQL Server databases, writing and debugging applications using Visual Studio,
and performance tuning. Scott designed the architecture (websites, class libraries,
and database) for the LearnItFirst.com websites and, most
re...
(Scott's full bio can be found here)
NOTE: This video is part of our
SQL Server 2005 Integration Services course.
This video is from Chapter
8:
Migrating and Upgrading From SQL Server 2000 DTS to SSIS in SQL 2005
Jump to a specific chapter: