Custom data flow component

Question

Post reply

Custom data flow component

TangoVictor

SSChampion

Points: 10975
More actions
December 31, 2009 at 9:45 am

#136331

I'm creating a custom pipeline transformation component and having problems establishing multiple inputs.
I've created the multiple inputs and can connect 2 data sources but then I can't open the component. If I change it back to 1 input then I can open and edit.
Hard to find any good examples. If anyone has done this, looking for anything to help.
thx, tom

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply

COZYROC One Orange Chip Points: 28499 More actions · Answer 1

Is there an error when you try to open the component?

---
SSIS Tasks Components Scripts Services | http://www.cozyroc.com/

TangoVictor SSChampion Points: 10975 More actions · Answer 2

I'll elaborate on this monday when I'm back in the office, but no I don't get any error message when working in BIDS and double click to open. It just sits there and does nothing. If I attach the BIDS process and override the validate method I can get an error which is unclear but it does point to the 2 inputs. Initially it was something to do with the synchronous output. So I changed it to asynchronous. Still getting an error but again not descriptive enough to point me in the right direction.

Possible I bit off more than I can chew on this one. I'm running out of time to be messing with this, need to start delivering something.

What I really need is an example of multiple inputs used in a custom transformation. I will reply Monday with the error message...

COZYROC One Orange Chip Points: 28499 More actions · Answer 3

Check this sample. It supports multiple inputs.

---
SSIS Tasks Components Scripts Services | http://www.cozyroc.com/

TangoVictor SSChampion Points: 10975 More actions · Answer 4

I downloaded that one already but I was more confused after looking at it. Are the inputs setup the same as a transformation? There are pieces I was looking for but didn't find. The structure was quite different from the samples I have been working off.

On monday I will look at it more.

TangoVictor SSChampion Points: 10975 More actions · Answer 5

Attached is the error message. I can only get this when running in debug with the VS process attached. When I double click it runs the Aquire Connection method then the validate method. At the end of the validate method the code return base.Validate() is executed then the method ends. The cursor is on the close curly brace for the validate method, i press F10 and then press it again, that is when the attached error comes up, but it does not come up every time.