+1
Hi,
A new client has asked me to help orchestrate a number of SSIS package executions. They would like to have K2 blackpearl call an SSIS package, wait for a return code, and, based on the return code, either go on to the next SSIS package (for a "success" return code) or to an error handling routine (for a "failed" return code).
What is the best way to making this happen within K2? Thank you in advance for any ideas/help you might be able to provide.
This has not been tested/implemented.
1. But perhaps create a SQL stored procedure that would execute the SSIS Package and return code as per:
2. Use the Out-of-the-box SQL server broker, to surface this stored procedure and perhaps create Smartobjects from it:
http://help.k2.com/onlinehelp/k2blackpearl/userguide/current/webframe.html#ws_sql_01.html
http://help.k2.com/onlinehelp/k2blackpearl/userguide/current/webframe.html#stored_procedures.html
http://help.k2.com/en/KB001451.aspx
3. Create a workflow with logic to execute the smartobject and take actions base on smartobject's return code.
+1
Thank you very much, Tin, for your help/direction. I will check it out and let you know how it goes.
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.
