Category Archives: SSIS 2014

It’s That Time of Year to Think About Your Career

If you work with SQL Server (or want to work with SQL Server), this is a good time of the year to think about your career. Why? It’s the holiday season and you should have some time off… unless you have a Crappy Job . You can use some of this time to advance your knowledge about SQL Server, especially the new version: SQL Server 2014. How? You can download a free 180-day version here . That version will carry you through the holidays and then some. Install it, poke around some, search for online…(read more)

[Re-] Updated: Creating a Custom SSIS 2012 Task

Apologies. My first edition of this post copied outdated links to this series. I have corrected the links but left the comments pointing out my earlier error. Thank you to those who let me know! :{> A while back I asked myself: “Self, do you think it is possible to create a custom SSIS 2012 task using Visual Studio 2012 Express?” That question launched a quest to learn the answer. In this series of posts I describe what I learned. I recently updated the material. You can find the updated series…(read more)

Join me for 3 Days of SSIS Training in Denmark – Advanced Integration Services 18-20 Nov 2014

I am honored to announce Advanced Integration Services will be delivered in cooperation with  in Aarhus, Denmark 18-20 Nov 2014. Target Audience The target audience for this course is intermediate SQL Server Integration Services developers (or quick learners) who wish to learn best practices and the more advanced stuff, and those who wish upgrade their existing SSIS skills to 2012. Since there are almost no changes between SSIS 2012 and 2014, this course will also be suitable for SSIS 2014 users…(read more)

SSIS Design Patterns Training in London 8-11 Sep!

A few seats remain for my course SQL Server Integration Services 2012 Design Patterns to be delivered in London 8-11 Sep 2014. Register today to learn more about: New features in SSIS 2012 and 2014 Advanced patterns for loading data warehouses Error handling The (new) Project Deployment Model Scripting in SSIS The (new) SSIS Catalog Designing custom SSIS tasks Executing, managing, monitoring, and administering SSIS in the enterprise Business Intelligence Markup Language (Biml) BimlScript ETL Instrumentation…(read more)

Presenting Enterprise Information Management in SQL 2012 and SQL 2014 in Reston 16 May!

I am honored to participate in the Reston SQL Server 2014 Launch Update event – a half-day event held 16 May 2014 at the Microsoft Reston Office. You can learn more and register here . Art Rask will kick-off the event with an overview of new features of SQL Server 2014, including: Integrated In-memory technology AlwaysOn HA / DR for mission-critical workloads Cloud and on-premises scenarios support Resource governance improvements Advanced security enhancements After this introduction, two tracks…(read more)

Presenting SSIS 2014 Data Flow Tuning Tips and Tricks in Boston 14 May!

I am honored to announce I will be presenting SSIS 2014 Data Flow Tuning Tips and Tricks at the New England SQL Server User Group Wednesday, 14 May 2014! SSIS 2014 Data Flow Tuning Tips and Tricks Want to go fast? This session is for you! Attend and learn techniques for developing, instrumenting, monitoring, and managing SSIS 2014 Data Flow performance in your data integration enterprise. If you will be in the Boston area 14 May, join us! Details here . :{>…(read more)