August 6, 2007 at 8:41 am
Hi,
As far as I know it is currently not possible to add a SSIS custom data flow transformation component by constructing it in the data flow task editor directly.
Is there some tool, designpattern etc that support this? That is: A tool that simplifies the construction of custom data flow components via 'reuse' of the graphical designer.
/LL
August 6, 2007 at 9:14 am
If I understand you, you want to save a dataflow with the basics in it for reuse? No, it was requested but is not implimented. Would be a nice feature.
Katmai is also lacking...
Cheers,CrispinI can't die, there are too many people who still have to meet me!It's not a bug, SQL just misunderstood me!
August 6, 2007 at 10:36 am
Yes, I have data flows in different places that do that same (similar) thing, eg. normalizing a telephone number. Instead of using copy-and-paste I would like the make a custom dataflow component out of the existing dataflow. This is possible programmatically but it would be nice to generate the component from the existing data flow (somehow).
I was a a bit amazed that this is lacking from SSIS since this is the basic decompositional tool in dataflow/functional programming. That is: Possibility to define named (at least first-order) transformations/functions.
/LL
August 7, 2007 at 8:24 am
The Wrox book "Professional SQL Server 2005 Integration Services" by Brian Knight, et. al. has 2 chapters devoted to creating custom components for SSIS. However, it requires Visual Studio, and quite a bit of programming from what I can see. I haven't had occasion to try it yet.
Sounds like you're looking for something a bit simpler to implement. On my current project I had a need for resuable functions to create IBM signed numbers and Julian dates. I found it easier to create SQL functions to do this upstream of the transformation rather than do it in SSIS.
Ed
August 7, 2007 at 9:35 am
if you create a script task or component, you should create a custom component for reuse. Faster, better, neater, easier to deploy etc.
I am not sure you could, or it would be feesable, to create a task which encompases a number of different tasks or components. Doubt it is because we would have seen people doing it by now.
And yes, that book is a good read.
Cheers,CrispinI can't die, there are too many people who still have to meet me!It's not a bug, SQL just misunderstood me!
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply