Custom SSIS Control Flow Task implemented in C++
- Hi Guys,
This is a question to the SSIS development team. I would like to know what are the requirements to implement custom SSIS Control Flow task in C++ . There is a documentation describing the process when implementing a managed task, but no such documentation exists for implementing a task in C++.
Thank you,
Ivan
Answers
You could write a custom task completely in C++ as long as the component supports the correct interfaces. You have to do it at your own risk becuase this is not something we support. Most of our stock SSIS tasks are implemented in managed code.
As Cho mentioned, the current POR is to only support managed custom tasks. Native interfaces are not intended to be used directly from your code and will not be supported.
All Replies
I'm not a member of the SSIS product group, but I have always interpreted this to mean that there is no unmanaged API for building custom tasks. Have you considered using Managed C++ for this?
Of course, I'd love to hear the official answer too...
You could write a custom task completely in C++ as long as the component supports the correct interfaces. You have to do it at your own risk becuase this is not something we support. Most of our stock SSIS tasks are implemented in managed code.
- What about data flow components? Are they under the same support restrictions?
Hi Cho,
Can you please elaborate more on the correct interfaces? Which are these interfaces? I'm willing to do it at my own risk and I know Microsoft has done this as well because there are a number of stock SSIS tasks implemented in unmanaged code. So with the correct information, my guess is the risk is pretty low. We will appreciate any information you can give back to the community. Obviously your developers have used some documentation internally to develop the SSIS stock components. Is it possible to talk with your SSIS team lead to release some more documentation?
Regards,
Ivan
- Yes, same story for Dataflow components. We don't release any public information on how to program against our native interfaces.
AFAIK, we don't have any plan to release the native interfaces information to public. I will check with out Product Manager (PM). Thanks
I guess we have to take the matter in our own hands for now. I have published a blog about our experience so far developing custom SSIS Control Flow Task. Enjoy!
As Cho mentioned, the current POR is to only support managed custom tasks. Native interfaces are not intended to be used directly from your code and will not be supported.
