DCOD workshops mission statement:

Use real-life exprerience to give people tools so they can discover themselves the logic of SQL Server's internal behavior. And make this complex matter sound simple.

Workshop concept
Contact Us

SSIS dataflow Performance tuning

Course description
This workshop will guide you through a number of dataflow optimizations you have to address if you don't want to run into problems when your solution needs to scale because of increasing data volumes.
This workshop is based on a presentation Geert Vanhove has given during the SQL Server OpenWorld 2007 conference in Lalandia , Denmark and was also selected for the upcoming 2008 European PASS Conference in Dusseldorf, Germany.

Target audience
Developers who are uncertain their functionally working SSIS packages will perform accurately when data volumes will increase and can't spend too much time investigating the ins and outs of the SSIS dataflow engine.


  • See lookup caching in action
  • Optimize data sources
  • Compare different data flow destinations
  • Analyze and evaluate memory buffer settings

    Location: At the DCOD office in Herk-de-Stad or on-site

    Duration: 1 day

    When: On demand on weekdays or Saturday (min 4 attendees on weekdays)

    Price: 600 / attendee

  • DCOD BVBA 2005 - Grote Hoolstraat 86/1 - 3540 Herk-de-Stad - Belgium - Tel: +32(0)479684160 - Email: info@DCOD.be