Skip to main content
Nintex Community Menu Bar
Solved

Execute SSIS package via Stored Procedure from K2 Five

  • October 16, 2018
  • 2 replies
  • 51 views
S
Forum|alt.badge.img+6

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?

Best answer by boringNerd1

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).


 

    2 replies

    B
    Forum|alt.badge.img+15
    • boringNerd1
    • Answer
    • October 17, 2018

    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).


     

    S
    Forum|alt.badge.img+6

    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....

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