Design Patterns for SSIS Performance (Presentation)

by Darren Green 21 Apr 2010 18:53
Here are the slides from my session (Design patterns for SSIS Performance) presented at SQLBits VI in London last Friday. Slides - Design Patterns for SSIS Performance - Darren Green.zip (86KB) It was an interesting session, with some very kind feedback, especially considering I woke up on Friday without a voice. The remnants of a near fatal case of man flu rather than any over indulgence the night before I assure you. With much coughing, I did turn the off the radio mic during the worst, and an interesting vocal range, we got through it and it seemed to be well received. Thanks to ... [More]

SSIS Tips & Tricks (Presentation)

by Darren Green 21 May 2009 09:01
This has been a rather well used presentation title but it does allow a certain degree of flexibility, and we covered a good range of topics in my session at the UK SQL Server User Group in Cambridge last night. Thanks to all who attended. Here is the rather limited slide deck and the all important demo packages for download as promised. For reference, high level topics covered were BIDS Helper Inserts and Updates Transactions Script Debugging Data Flow Checkpoints I’ll update the post with a link to the Live Meeting recording when I get it. Presentation & Demo ... [More]

Making more of SSIS in 2008 (Presentation)

by Allan Mitchell 13 Mar 2008 01:42
Download the slide deck from my Making more of SSIS in 2008 presentation, first presented at the SQLBits II (The SQL) Community Conference. Abstract Integration Services in SQL Server 2008 is Microsoft’s Enterprise Class ETL Tool. In this session I am going to show you how to use it to do so much more than simply taking a table from one database to another. I am going to show you gems like Change Data Capture, Threading models, Fuzzy Logic, Integration with SSAS and SSRS, Lookup transform caching options and what they mean to you. This session is advanced (level 400) session so yo... [More]

Extending SSIS with custom Data Flow components (Presentation)

by Darren Green 6 Mar 2008 14:00
Download the slides and sample code from my Extending SSIS with custom Data Flow components presentation, first presented at the SQLBits II (The SQL) Community Conference. Abstract Get some real-world insights into developing data flow components for SSIS. This starts with an introduction to the data flow pipeline engine, and explains the real differences between adapters and the three sub-types of transformation. Understanding how the different types of component behave and manage data is key to writing components of your own, and probably should but be required knowledge for anyone bu... [More]

Advanced Topics in SQL Server 2005 SSIS (Presentation)

by Allan Mitchell 15 Oct 2007 14:00
Download the slides and sample code from the Advanced Topics Using Microsoft SQL Server 2005 Integration Services presentation, first presented at the SQLBits 2007 Community Conference. In this session we looked at some of the not so often thought about areas of the SSIS toolbox. Perhaps they aren't considered true ETL by some people or are simply not seen but we think they are really useful weapons in our ETL armoury. Highlights include: Loading partitions directly Consuming a package in SSRS Using a DM algorithm in the pipeline to see... [More]

Preview of SSIS in SQL Server 2008 (Presentation)

by Allan Mitchell 15 Oct 2007 14:00
Download the slides and samples from the Preview of SSIS in SQL Server 2008 presentation, first presented at the SQLBits 2007 Community Conference. In this session we looked at some of the new and improved features of SSIS coming in SQL Server 2008. Highlights include: Looking at the new pipeline limiter The new threading engine The arrival of C# as a scripting language option Change Data Capture(CDC) Presentation & Samples (360KB) Preview of SSIS in SQL Server 2008.zip

Extending SSIS with Custom Tasks (Presentation)

by Darren Green 13 Oct 2007 14:00
Download the slides and sample code from the Extending SSIS with Custom Tasks presentation, first presented at the SQLBits 2007 Community Conference. The sample demonstrates a custom task with a connection property, including a property grid drop-down (UITypeEditor) to list all your connections and also add new connections, and a password property flagged as sensitive to honour the package protection level. It also illustrates how to create a user interface for your task. Abstract This session is all about developing for SSIS, writing .Net code to create your own tasks. We cover b... [More]

SQL Server Integration Services - Thinking Outside of the DTS Box (Presentation)

by Darren Green 19 May 2005 14:00
Download the slides and sample code from our SQL Server Integration Services - Thinking Outside of the DTS Box session at the 2005 PASS European Conference. Presentation & Samples (521KB) SQL Server Integration Services - Thinking Outside of the DTS Box