An Introduction to the Common DTS Tasks - Video Series Video Category: Working with the Common Tasks in DTS Skill Level: 100 (Beginner) Versions/Editions Covered: SQL Server 2000 A nice walk-through of the basic DTS tasks inside the DTS Designer

Videos in this Series:

Title Skill Length Download Part 1 - A Basic Walkthrough of the Built-In Tasks   100 10 mins. Download Part 2 - A Basic Walkthrough of the Built-In Tasks   100 10 mins. Download

< Return to list of all videos

Miscellaneous Bits & Pieces:

Helpful Tools for your SQL Server: Be sure to download the "SQL Server 2000 Security Tools" from microsoft.com/sql Security Tip: Do not allow applications to issue SELECT,INSERT,UPDATE, or DELETE statements to your database. Instead create a set of stored procedures and require that your applications use these "interfaces" into your database Want to see something cool? Run DBCC PERFMON WITH TABLERESULTS