title: Execute SSIS Package Remotely C#
body: <p>My web app pass a parameter to the SSIS package and executes it. Everything runs smooth on the development machine. But when i deploy the app to production server, the execution fails.</p>
  
  <p>Error is "Failed to connect to server ."</p>
  
  <p>It fails at the second line</p>
  
  <pre><code> var ssisCon = new SqlConnection(connectString);
   var integrationSvc = new IntegrationServices(ssisCon);
  </code></pre>
  
  <p>Here is my connection string:</p>
  
  <pre><code>  &lt;connectionStrings&gt;
      &lt;add name="SSISHOST" connectionString="Data Source=TESTSERVER\SQL2012;Initial Catalog=master;Integrated Security=SSPI;" /&gt;
    &lt;/connectionStrings&gt;
  </code></pre>
  
  <p>Application on IIS runs under application pool using my credentials, so it can't be a permission issue, so if everything runs fine on my machine, how does it get broken after publishing.</p>
  
  <p>I can't seem to figure out what is breaking the app, Is it the connection string? I can provide more information if someone needs.</p>