Introduction to SSIS in SQL Server 2005 - Video Series Video Category: SSIS: SQL Server Integration Services and SSIS Package Management Skill Level: 100 (Beginner) Versions/Editions Covered: SQL Server 2005 This series focuses on the basics of Integration Services (SSIS) including the new architecture, how to create packages in the SQL Server Business Intelligence Development Studio (BI Studio for short), and how to deploy and schedule packages. This is a must see series for those of you who are either new to SQL Server 2005 or who are coming from previous versions of SQL Server and have used DTS in the past. SSIS is so far removed from DTS that you'll definitely want to watch these videos to get up to speed quickly on SSIS.

Videos in this Series:

Title Skill Length Download Pt. 1- Introduction to SQL Server 2005's Integration Services   200 14 mins. Download Pt. 2 - Creating Your First SSIS Packages (Integration Services Packages)   200 16 mins. Download Pt. 3 - Introduction to SSIS Package Deployment   200 11 mins. Download Pt. 4 - How to Schedule an SSIS Package (Introduction)   200 9 mins. Download

< Return to list of all videos

Miscellaneous Bits & Pieces:

The command-line command "xcopy" has been improved to allow you to create decrypted files at the destination (hint: use the /g option) SQL Server 2000 Service Pack 3 Additions/Changes: New database role and server configuration to allow cross-database ownership chaining Helpful Keyboard Shortcuts: "Windows key" + "M" minimizes all windows