Run .NET 4 code from script component SSIS 2008
I need to run custom code from SSIS script component. As I know it support开发者_开发问答s .NET 2-3.5. Can you tell me please a workaround of doing this?
Thanks.
Create a web service/WCF service to call the .NET 4.0 custom code and invoke the custom code from the Script Component
through the service.
Here is a link that shows How to Configure an SSIS Package to Access a Web Service using WCF
. It is not exactly the same as what you are looking for but I hope that should give you an idea.
Compile it as an .exe and run it in an 'Execute Process Task'
精彩评论