title: How to get the value from step1 to step2 in sql Job
body: <p>I need to create a SQL JOB.</p>
  
  <p><strong>Step1:</strong> 
  Insert a Row into TaskToProcess Table and return ProcessID(PK and Identity)</p>
  
  <p><strong>Step2:</strong>
  Retrive the ProcessID which is generated in <strong>step1</strong> and pass the value to SSIS package and execute the SSIS Package.</p>
  
  <p>Is this Possible in SQL server JOB??</p>
  
  <p>Please help me on this</p>
  
  <p>Thanks in advance.</p>