Skip to main content
Nintex Community Menu Bar

How do I execute SSIS package from K2 Five?

Below is my approach:

  1. K2 Five calls Stored Procedure
  2. Stored Procedure calls SSIS package(s)
  3. SSIS package(s) could possibly call other SSIS packages
  4. SSIS Package(s) returns execution status to a SQL Table or Stored Procedure
  5. K2 reads the execution status to perform other actions within Workflows or SmartForms 

Here is the issue: I need restart certain SSIS packages if they failed to execute. How do I accomplish this?

Why not make use of the table that stores the execution results? You can create a SmartObject that reference those table, and in your workflow, add a decision step and make use of that SmartObject to check the execution results.


 


If execution fails, route it back to the step where you execute your stored procedure (via SmartObject).


 

Looks like a great solution. Trying it now. Will post my update after I get this working. Currently, I am using SSIS packages to store the execution results in tables. Might have to extend this table to store a custom messages to display in K2 Dashboard. Marching along....

Reply


Sidebar Buttons
Nintex Community Home Contact Nintex Support Email Nintex Community Check Nintex Status
Terms & ConditionsCookie Settings