CLR Integration - call function and returning dataset/datatable?

Hi,

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

Client Side Printing

We just installed SP2 on our SRS server. However, the client-side printing
is returning an error. How can we disable this feature?You can do that by deactivating the function with a property called
EnableClientPrintControl. Due to untested I refer only to that post:
http://groups.google.de/group/microsoft.public.sqlserver.reportingsvcs/browse_frm/thread/9bf4cd750acf0237/d6cb4e15cb1b7d57?q=disable+print+OR+printing+Control&rnum=1&hl=de#d6cb4e15cb1b7d57
HTH, Jens Suessmeyer.
--
http://www.sqlserver2005.de
--
"TechnoSpyke" <technospyke@.yahoo.com> schrieb im Newsbeitrag
news:eJFeS$gWFHA.3540@.TK2MSFTNGP15.phx.gbl...
> We just installed SP2 on our SRS server. However, the client-side
> printing is returning an error. How can we disable this feature?
>|||Ok, the error was due to an older control (downloaded the beta version).
After removing that, and downloading a new one, the error is gone.
Still, I dont know where to enable/disable client-side printing. The SP2
document says there is a new Report Server system property called
EnableClientPrinting with a default value as True. I don't see this
property on any of the config files for ReportServer. Where will I change
this?
TIA.
Marlon
"TechnoSpyke" <technospyke@.yahoo.com> wrote in message
news:eJFeS$gWFHA.3540@.TK2MSFTNGP15.phx.gbl...
> We just installed SP2 on our SRS server. However, the client-side
> printing is returning an error. How can we disable this feature?
>|||Found this on the support articles: How to disable client-side printing
http://support.microsoft.com/kb/897121/
Works, but, I was surprised I had to write a little console app to set RS
system properties. Adding/changing config settings would have been more
convenient.
Marlon
"TechnoSpyke" <technospyke@.yahoo.com> wrote in message
news:eZQnjWhWFHA.3620@.TK2MSFTNGP09.phx.gbl...
> Ok, the error was due to an older control (downloaded the beta version).
> After removing that, and downloading a new one, the error is gone.
> Still, I dont know where to enable/disable client-side printing. The SP2
> document says there is a new Report Server system property called
> EnableClientPrinting with a default value as True. I don't see this
> property on any of the config files for ReportServer. Where will I change
> this?
> TIA.
> Marlon
> "TechnoSpyke" <technospyke@.yahoo.com> wrote in message
> news:eJFeS$gWFHA.3540@.TK2MSFTNGP15.phx.gbl...
>> We just installed SP2 on our SRS server. However, the client-side
>> printing is returning an error. How can we disable this feature?
>