New SQL Server Integration Services Video Tutorial: Using the Package Migration Wizard to Upgrade Your DTS Packages to SSIS
Using the Package Migration Wizard to Upgrade Your DTS Packages to SSIS - view details
This video is an excellent overview of what to expect when running SQL Server 2005's Package Migration Wizard, the tool that migrates/upgrades your DTS packages to SSIS packages. If you are running SQL Server 2000 currently and want to know what challenges you face when moving to SSIS (as if you don't already know), then this video can help you spot common issues and recommend alternative techniques.
Highlights from this video:and much more.
- What options you have for migrating from SQL Server 2000 to SQL Server 2005 (with respect to Data Tranformation Services)
- Migrating one package or multiple packages (such as all packages)
- Launching the Package Mi gration Wizard (PMW) from the command line (DOS prompt)
- Common failures/challenges/issues with the PMW
- Migrating the Dynamic Properties Task
- Migrating Variables and the Execute SQL Task
- Upgrading ActiveX Script Tasks
- Migrating FTP Tasks
- Moving Transform Data Tasks and the common choices/options the PMW will use
In the end, you have to decide whether to rewrite/redesign/rearchitect your DTS packages when you move to SSIS or you can use the Package Migration Wizard. This video (and the rest of the videos on the PMW) will help you make this choice.
- Source: SSIS videos
- Category: Migrating and Upgrading From SQL Server 2000 Data Transformation Services (DTS) to SSIS in SQL 2005
- Skill Level: 200 (Beginner - Intermediate)
- Length: 18:31 (11.3MB)
- Applies to Versions: SQL Server 2005
- Full Details
To download this video, Login, then visit the video's detail page and click "download". You might also enjoy our free training videos.
Note: You must have the TSCC codec installed to view this video
Keywords Associated with this video: Execute DTS 2000 Package task, upgrade, upgrading, migration, migrate, legacy
0 Comments:
Post a Comment
<< Home