title: How to pass variables to an SSIS package from a C# application
body: <p>Basically i am trying to build an application that uses SSIS to run a series of sql stuff.</p>
  
  <p>Here is my code thus far:  </p>
  
  <pre><code>        public JsonResult FireSSIS()
      {
          string x = string.Empty;
          try
          {
              Application app = new Application();                
              Package package = null;
  
              package = app.LoadPackage(@"C:\ft\Package.dtsx", null);
  
              Microsoft.SqlServer.Dts.Runtime.DTSExecResult results = package.Execute();
              if (results == Microsoft.SqlServer.Dts.Runtime.DTSExecResult.Failure)
              {
                  foreach (Microsoft.SqlServer.Dts.Runtime.DtsError local_DtsError in package.Errors)
                  {
                      x += string.Concat("Package Execution results: {0}", local_DtsError.Description.ToString());
                  }
              }
          }
  
          catch (DtsException ex)
          {
             // Exception = ex.Message;
          }
          return Json(x, JsonRequestBehavior.AllowGet);
      }
  </code></pre>
  
  <p>Does anybody know how to pass a variable to the package itself in this way?</p>