Extending SSIS with custom Data Flow components (Presentation)

Posted on SQLIS See other posts from SQLIS
Published on Thu, 06 Mar 2008 14:00:00 +0100 Indexed on 2010/05/26 7:12 UTC
Read the original article Hit count: 350

Filed under:

Code Development

|

Data Flow

|

Destinations

|

Sources

|

Presentations

|

Transformations

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 building packages at all. Using sample code throughout, I will show you how to write components, as well as highlighting best practice and lessons learned.

The sample code includes fully working example projects for source, destination and transformation components.

Presentation & Samples (358KB) Extending SSIS with custom Data Flow components.zip

© SQLIS or respective owner

Related posts about Code Development

Soapi.CS : A fully relational fluent .NET Stack Exchange API client library

as seen on Stackapps - Search for 'Stackapps'
Soapi.CS for .Net / Silverlight / Windows Phone 7 / Mono as easy as breathing...: var context = new ApiContext(apiKey).Initialize(false); Question thisPost = context.Official .StackApps .Questions.ById(386) .WithComments(true) .First(); Console.WriteLine(thisPost.Title); thisPost … >>> More
Super Joybox 5 HID 0925:8884 not recognized as joystick in Ubuntu 12.04 LTS

as seen on Ask Ubuntu - Search for 'Ask Ubuntu'
Problem: When using the "Super JoyBox 5" 4 port playstation 2 to USB adapter, the device is not recognized as a joystick. there is no js0 created, but instead another input eventX and mouseX are created in /dev/input. When using the directional buttons (up down left right) on a Playstation 1 controller… >>> More
How to resolve: 'cmd' is not recognized as an internal or external command?

as seen on Stack Overflow - Search for 'Stack Overflow'
I have searched other forums to solve this error where it would either end with: 1.) re-install OS 2.) Setting path variable C:/Windows/System32 The latter did not work, and as you can probably imagine, I do not want to have to re-install my OS... I am running the command "mvn jetty:run" and the… >>> More
Small Business Web Site Development - 3 Tips For Getting Business Web Development

as seen on Ezine Articles - Search for 'Ezine Articles'
If your want to grow your Small Business, Web Site Development is a crucial ingredient for this new growth going forward. Web development is more than putting words or content on a web page. Today more than 50% of folks looking for products or services use the internet to find what they needs. Here… >>> More
Surface development: it’s just like software development

as seen on Geeks with Blogs - Search for 'Geeks with Blogs'
Surface is magic. Everyone using it seems to think that way. And I have to be honest, after working for almost 2 years with the platform I still get that special feeling the moment I turn on the unit to do some more work. The whole user experience, the rich environment of the SDK, the touch, even… >>> More

Related posts about Data Flow

Introduction to Control Flow and Data Flow of SSIS 2008

as seen on Internet.com - Search for 'Internet.com'
Learn about two primary components of SQL Server 2008 Integration Services packages and their graphical representation in the Business Intelligence Development Studio. >>> More
timetable in a jTable

as seen on Stack Overflow - Search for 'Stack Overflow'
I want to create a timetable in a jTable. For the top row it will display from monday to sunday and the left colume will display the time of the day with 2h interval e.g 1st colume (0000 - 0200), 2nd colume (0200 - 0400) .... And if i click a button the timing will change from 2h interval to 1h interval… >>> More
Reading data from an Entity Framework data model through a WCF Data Service

as seen on ASP.net Weblogs - Search for 'ASP.net Weblogs'
This is going to be the fourth post of a series of posts regarding ASP.Net and the Entity Framework and how we can use Entity Framework to access our datastore. You can find the first one here , the second one here and the third one here . I have a post regarding ASP.Net and EntityDataSource. You… >>> More
SQL SERVER – Advanced Data Quality Services with Melissa Data – Azure Data Market

as seen on SQL Authority - Search for 'SQL Authority'
There has been much fanfare over the new SQL Server 2012, and especially around its new companion product Data Quality Services (DQS). Among the many new features is the addition of this integrated knowledge-driven product that enables data stewards everywhere to profile, match, and cleanse data.… >>> More
Modifying a HTML page to fix several "bugs" add a function to next/previous on a option dropdown

as seen on Stack Overflow - Search for 'Stack Overflow'
SOF, I've got a few problems plaguing me at the moment and am wondering if anyone could assist me with them. I'm trying to get Next Class | Previous Class to act as buttons so that when Next Class is clicked it will go to the next item in the dropdown list and for previous it would go to back one… >>> More