Skip to main content
Hi, I am using K2 to call Microsoft SQL Server Integration Services (SSIS), in order to execute SSIS packages. I am successfully calling a stored procedure, sp_start_job, passing the name of the SSIS package and server name, and executing the job. What I would like to do is to have the workflow follow different paths, based on the success or failure of the SSIS package. After I know the package is completed, I can execute another stored procedure, sp_help_job, to find out its success/failure status. The problem I am having is figuring out when SSIS has completed. Here is an approach I have been looking at (which may or may not be the right way to go). I have been looking into using an asynchronous server event*, in order to stop the process flow in order to wait for SSIS to complete the execution until the process resumes. What I can’t seem to figure out is how I can pass the Serial Number mentioned in the link below to SSIS and get it to then send it back. Any thoughts on how to link K2 and SSIS, so I know when an SSIS package execution is complete would be appreciated. Thanks in advance for any help, Kevin *http://help.k2.com/onlinehelp/K2blackpearl/DevRef/current/default.htm#CustomCodeWorkflow4.htm#tracksearch=asynchronous server event

Hi KTS

 

It sounds like you need to use a package level parameter for your SSIS package to store the Serial No, and then call a code event in your package when it completes to complete the server item using that Serial No. When you execute your stored procedure you will to pass in the Serial Number as your parameter. Have a look at the following link that describes how to execute a stored procedure. 

 

https://msdn.microsoft.com/en-us/library/jj820152(v=sql.120).aspx


Reply