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

Allan Mitchell, SSIS Editor

Allan Mitchell

Allan Mitchell is the joint owner of Konesans Ltd, a small UK based consultancy specializing in SQL Server, and most importantly SQL Server Integration Services. Having been working with SQL Server from 6.5 onwards, he has extensive experience in many aspects of SQL Server, but now focuses on the BI suite of tools. He is a recognised SQL Server MVP and co-author of Professional SQL Server 2005 Integration Services, a book written for developers, DBAs, and casual users who hope to use SSIS for transforming data, creating a workflow or maintaining their SQL Server environment. Allan is a member of the SQLBits management committee – the largest SQL Server community event in Europe, and a regular presenter at user groups and industry conferences throughout the world.

His online presences include:

• Blog: http://www.sqlis.com/author/Allan%20Mitchell.aspx
• Company: http://www.konesans.com
• Email: allan.mitchell@konesans.com