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:

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 SQL Server 2000 Service Pack 3 Additions/Changes: A new Transact-SQL function "fn_get_sql" was introduced to help DBAs diagnose problematic processes Keyboard Shortcut for Query Analyzer: Shift+F1 brings up the context-sensitive help in Books Online