SQL 2005 Stored Procedure Interaction and BlackPearl

First, in my humble opinion you should either:

1. 
   
2. Write a web service that call use the stored procedure.  Then have InfoPath call the stored procedure.
   
3. Write a SmartObject Service to call the stored procedure.  Then create a SmartObject.  From there you can use InfoPath integration to call the SmartObject or use a SmartObject event in BlackPearl to save the data. (http://k2distillery.blogspot.com/2007/11/create-custom-blackpearl-smartobject.html - instructions on how to create a smartobject service).

Second, I have heard that the templates from K2 2003 can now be used with BlackPearl SP1 but I have not used them.  Plus I am not a real fan of using the SQL (http://k2distillery.blogspot.com/search/label/K2.net%202003) and prefer to use either of the above approaches.  However they take a little more time to put together but you will have a more solid architecture moving foward.

Jason

I agree with japergis' suggestions, with #2 being the most reusable within a K2 blackpearl environment.

Additionally, the out of box K2.net 2003 SQL Data Event did not interact with stored procs.