title: How to run SSIS packages from an external application?
body: <p>I have an application I am writing that accepts files of various formats. Then I write code for each format (csv, excel, xml) to convert it and enter it into a SQL Server database. This is fine but I was just looking into SSIS and wondering if this would help.</p>
  
  <p>The main question though is how do I run these packages within my own code? Is it easy to pass parameters? If I move this web app to another server does it depend on other components being on that server (maybe SQL Server 2012 installed)? Or is it just some DLLs I can reference from my web app?</p>
  
  <p>All the demos I see are about using the SSIS tool but I am more interested in how difficult it is to call packages with parameters from my code.</p>