Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Custom data flow component.. Expand / Collapse
Author
Message
Posted Tuesday, December 14, 2010 2:40 PM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Friday, September 12, 2014 11:45 AM
Points: 336, Visits: 867
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
Posted Wednesday, December 15, 2010 12:46 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Today @ 9:31 AM
Points: 5,162, Visits: 12,010
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



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

When you ask a question (and please do ask a question: "My T-SQL does not work" just doesn't cut it), please provide enough information for us to understand its context.
Post #1034929
Posted Wednesday, December 15, 2010 5:16 AM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Wednesday, June 18, 2014 3:28 AM
Points: 1,044, Visits: 1,839
Phil has suggested a great resource!!
Just out my sheer curiosity...what custom ability you desire to add?


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
Posted Wednesday, December 15, 2010 7:53 AM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Friday, September 12, 2014 11:45 AM
Points: 336, Visits: 867
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
Posted Thursday, December 16, 2010 8:44 AM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Sunday, September 14, 2014 3:17 PM
Points: 1,118, Visits: 2,224
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 »

Add to briefcase

Permissions Expand / Collapse