Custom data flow component..

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2005 » SQL Server 2005 Integration Services » Custom data flow component..

Custom data flow component..

Rate Topic

Display Mode

Topic Options

Author

Message

Learner1

Posted Tuesday, December 14, 2010 2:40 PM

Old Hand

Group: General Forum Members
Last Login: Thursday, May 23, 2013 9:02 PM
Points: 323, Visits: 804

Hi all.

I am very new to SSIS custom data flow components...

I have to build a data flow destination custom component , that will be used to map columns of a particular table....

Actually the requirement is that we have a table that is used as a destination in several packages and we have to map it again and again...now we want to have a component that just takes the connection manager and maps all the columns of that table...

Is there anything like this that can be build in SSIS...?

Any help is appreciated...

---------------------------------------------------

Thanks

Post #1034782

Phil Parkin

Posted Wednesday, December 15, 2010 12:46 AM

SSCarpal Tunnel

Group: General Forum Members
Last Login: Today @ 11:03 AM
Points: 4,324, Visits: 9,664

This might help you.

Your description is a little terse, but I get the gist. No matter how many times you have to map the columns of the table you are referring to, I still suspect that it will take less time than developing a custom component Smile

____________________________________________________________________________________________

Help us to help you. For better, quicker and more focused answers to your questions, consider following the advice in this link:

http://www.sqlservercentral.com/articles/Best+Practices/61537/

If you are asking for help and your post does not contain a question, you should expect responses which do not contain any answers. Put a question mark in there somewhere - it's not rocket science.

Post #1034929

Raunak Jhawar

Posted Wednesday, December 15, 2010 5:16 AM

SSC Eights!

Group: General Forum Members
Last Login: Today @ 4:30 AM
Points: 946, Visits: 1,740

Phil has suggested a great resource!!
Just out my sheer curiosity...what custom ability you desire to add? Smile

Regards/Raunak
Now a member of Linkedin

Please visit the all new Performance Point Forum
Please visit the all new Data Mining and Business Analytics Forum

Post #1035032

Learner1

Posted Wednesday, December 15, 2010 7:53 AM

Old Hand

Group: General Forum Members
Last Login: Thursday, May 23, 2013 9:02 PM
Points: 323, Visits: 804

Phil Thanks for your suggestion,I really like it and prefer it too, but still I have to develop a script for this, as this is assigned to me.

Is it so diificult to build a custom task...

@Raunak
My requirement:
requirement is to build a custom destination adapter, to map a particular tables column that is used again and again in my packages....

The task should accept a connection manager and just map columns of the table required...

The initial requirement is this but can extend in future by adding certain transformation codes to it...as its repeated steps in all the packages..

hope its clear..
I did find some detination adapters in this link but not sure where to look for the sample code...
pasting the link as its very useful one http://ssisctc.codeplex.com/

---------------------------------------------------

Thanks

Post #1035147

CozyRoc

Posted Thursday, December 16, 2010 8:44 AM

Ten Centuries

Group: General Forum Members
Last Login: Sunday, June 09, 2013 7:39 AM
Points: 1,106, Visits: 2,120

Developing custom data flow component is not pretty. May I ask you how would you know which columns are mapped to which destination table columns? Are you going to have a special control table with metadata? Perhaps there might be another solution available.

Another question can you elaborate in what data flows you want to use this component? Is it straight transfer or you have different transformations preceding this destination table?

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

Post #1035898

« Prev Topic | Next Topic »

Permissions