Custom Transformation Component tutorial

Hi all,

Is there any tutorial to learn how custom transformation component works? maybe a blog, pdf or something...

Specifically, i need to learn how to generate an output column composed from 3 input columns. The problem is i dont know how to set the column value... anyone have some sample code?

Thanks!

I don't think there is any one source. Books Online has some very good topics on this. Make sure you have the latest version Feb 2007, not just the one which came with the original media.

The MS downloads site has some good samples too, just search for SSIS on there. The samples cover lots of functions and build on each other, even when non functional as they stand.

There plenty of sites with articles but I'll cheat and point to some on mine as I know them -

The ReverseString Component Explained
(http://www.sqlis.com/25.aspx)

When to use ProcessInput or PrimeOutput in your Component
(http://www.sqlis.com/24.aspx)

You can also buy books.

|||

Thanks Darren,

I need this new calculated output column as well as the same 3 columns that were the input of the component.

I have been trying my self using msdn, the problem is that , either i get the new column or the three ones, not these 4 columns i need...

I'll read this articles you post.

Thank you.

|||

Sorry for my insistence...

How can i link the inputs of the "custom transformation component" to its outputs in order to use this data in next step?

It's possible to mix this kind of outputs with other outputs generated by the objects?

thanks

|||

I do not really understand the question. Link inputs, why? Do you have multiple inputs? Do you mean an input or an input column?

You can "link" the input to the output via the SynchronousInputID property of the output makes a synchronous component.

Synchronous vs asynchronous is explained in Books Online.

If you have a synchronous component (make sure you know what that mean, see BOL), then an input column is always an "output" column, but it does not appear in the columns collection of the output itself. You can change data and it is available to downstream components.

|||

Dear Friend,

See this example:

http://pedrocgd.blogspot.com/2007/05/ssis-populating-dimension_28.html

Helped? :-(

Regards!