Novick Software
SQL Server Consulting Design Programming Tuning

  andy novick is a sql server mvp



Introduction to SQL Server Integration Services

Everyone who works with data ought to get to know SQL Server Integration Services (SSIS) the successor to SQL Server's DTS tool  for importing and exporting data.  It's not just a reworking  of the old DTS, instead it's a complete high performance ETL (Extract Transform and Load) tool  that competes with the best of breed ETL products but comes packaged  with the SQL Server and embedded in Visual Studio.  It can be  intimidating at first but once you get to know your way around it's not  difficult and can be extremely powerful.  Topics:
  • What is SSIS and what is it good for
  • Importing Data with the Import/Export Wizard (SSIS in disguise)
  • The ETL (Enter-Test-and-Load) paradigm
  • What is BIDS (Business Intelligence Development Studio)?
  • Implementing the SSIS ControlFlow and DataFlow


Be sure to read the Readme.Txt file.  The package references specific file locations and a SQL Server Instance.  You'll have to change them to match your system.

Download the slides file: Updated 3/5/10

Download the example file:   Updated 3/5/10



New England Visual Basic Pro
March 4, 2010




Personal Blog

New Tips:

Use dsinit to set the SQL Server instance for Windows Azure dev storage


Nov 7, '12
Loser: DB

Full Schedule