Fastload, context connection and CLR stored procs

Fastload, context connection and CLR stored procs

Post by R2VvZmYgQ2 » Thu, 07 Feb 2008 06:04:14


I have an app that:
1. creates a temp table
2. uses fastload interface to insert rows into table
3. calls stored proc to process rows
Everything is done on the same connection.

If the stored proc is a CLR stored proc, the temp table is visible but
always appears empty (CLR stored proc is using the context connection).

If the stored proc is TSQL, everything works as it should (temp table is
visbile and has rows).

Is this some limitation of context connection? possibly in conjunction with
fastload? Anyone have any ideas?
 
 
 

Fastload, context connection and CLR stored procs

Post by Niels Berg » Thu, 07 Feb 2008 06:37:58


This seems to have something to do with the IRowsetFastload interface. A
SQLCLR based proc works fine with temp-tables otherwise. I need to dig
into it a bit more though.

Niels

 
 
 

Fastload, context connection and CLR stored procs

Post by R2VvZmYgQ2 » Thu, 07 Feb 2008 07:01:33

Nevermind... just an error on my part that was masking errors from the clr
proc.