title: Running SSIS from an SQL job by passing parameters
body: <p>Is it possible to send parameters like @inputfile, @packagepath etc. to my sql job which will run my SSIS?</p>
  
  <p>Currently I am configuring my path, package name in the job properties itself to run it.</p>
  
  <p>I know one way is to define a command</p>
  
  <p>@command = exec my_stored_procedure @parameter1 , @parameters2</p>
  
  <p>and include this in the job.</p>
  
  <p>But can't I do it without calling the stored procedure , directly from the job ?</p>