title: How to use SSIS package in C# application without installation SSIS on Server, is it possible?
body: <p>I have few questions about the capability of SSIS package.
  I want to create an SSIS package to import data from Excel to Sql server conditioned Connectoin manager needs to be dynamic i.e. should be set programatically using C#.
  Is it possible ?</p>
  
  <p>Also if I am integrating this package to be executed via web page when user clicks on button then Do I need to have SSIS installed on Sql server or adding reference to the needed DLL's will work out.</p>