I'm very new to Yukon and the CLR integration, but I think I understand the basics. I have worked through the CLR tutorial on MS demo servers in which a function was created in vb.net that sql server could call, returning a string.
One thing I am wondering is if sql server can call a .net function that returns a dataset or a datatable. Would I be able to query directly off of the dataset returned by the function? The reason i ask is because I would like to be able to do this:
Create a function in .net that calls a web service that returns a large query to a datatable or dataset as part of a SSIS package that uploads that query result into our datawarehouse. Web service task in SSIS does not currently work for the web service in question.
I would greatly appreciate any advice.
Regards,
Darrell
Have you taken a look at table-valued functions? These allow you to return a table of data from the CLR, which you could then insert into your database.
Cheers,
-Isaac
No comments:
Post a Comment