Hi,

I've created my own custom data flow transformation task (using C#) that
will parse a name and output the various name parts. In the
ProvideComponentProperties method, I create 5 output columns (prefix, f, m,
l, and suffix). In the ProcessInput method, I parse the input and add the
name parts to the buffer. The bad thing is that I’m making an assumption on
the position of the Full Name input column within the buffer.

I would like the “user” to be able to map their input to a known Full Name
column so I don’t have to make that terrible assumption. This is the first
SSIS task I’ve tried to create and I haven’t been able to find very many
examples online.

Any help is greatly appreciated!

Thank you,

Marshall