SQL Server Integration Services Articles

• SSIS Overview
  • Services & Utilities
  • Data Import/Export Wizard
  • Editing Packages with BIDS
  • Transformations
  • Tasks
  • Scripting
  • Script Debugging
  • Slowly Changing Dimension Wizard
  • Using Checksum to Load Data into Slowly Changing Dimensions
  • Killing Sessions with SSIS
• XML for Data Exchange

Bulk Copy (BCP) and Bulk Insert Articles

• BCP - Overview
  • BCP Syntax
  • Using BCP from SQL Server
• Bulk Insert SELECT...INTO

Data Transformation Services (DTS) Articles

DTS is the old (SQL 2000) method of importing and exporting data from SQL Server. It's been replaced with SSIS, but there's still plenty of companies using DTS.

• Data Transformation Services
  • DTS Import/Export Wizard
  • Example of DTS Package

SQL Server Integration Services Tutorial Videos

Solid Quality Mentors has produced a series of screencast videos to show how to get started with Microsoft Business Intelligence. These videos were provided for you courtesy of Microsoft Developer and Platform Evangelism:

• Query-Driven Email Delivery System Tutorial
• Loading and Integrating Data from Multiple Sources
• Identifying and Importing New Customers by Using Fuzzy Lookups
• Slowly Changing Dimensions Tutorial
• Advanced SSIS Package Design Tutorial
• How to Design Dimensions Tutorial
• Advanced Dimension Design Tutorial
• Using the SSAS Cube Wizard
• Cube Calculations Tutorial
• Designing Reports on the UDM