title: Running Integration services SSIS on .net core 3.0
body: <p>We are in the process of porting one WPF application to .net core and we sort of got stuck on SSIS portion. Previously we used <code>Microsoft.SqlServer.Management.Sdk.Sfc</code> and <code>Microsoft.SqlServer.Smo</code> to run SSIS using this code:</p>
  
  <pre><code>    public void SSISUpload()
      {
          string targetServerName = "server";
          string folderName = "Project1Folder";
          string projectName = "Integration Services Project";
          string packageName = "SSISPackage/Package.dtsx";
  
          // Create a connection to the server
          string sqlConnectionString = "Data Source=" + targetServerName +
              ";Initial Catalog=master;Integrated Security=SSPI;";
          SqlConnection sqlConnection = new SqlConnection(sqlConnectionString);
  
          IntegrationServices integrationServices = new IntegrationServices(sqlConnection);
          Catalog catalog = integrationServices.Catalogs["SSISDB"];
          CatalogFolder folder = catalog.Folders[folderName];
          ProjectInfo project = folder.Projects[projectName];
          PackageInfo package = project.Packages[packageName];
  
          // Run the package
          package.Execute(false, null);
      }
  </code></pre>
  
  <p>However, the above references tie to .NET Framework and do not seem to have bindings for .net core or standard. We tried using <a href="https://www.nuget.org/packages/Microsoft.SqlServer.SqlManagementObjects/" rel="nofollow noreferrer">Microsoft.SqlServer.SqlManagementObjects</a>, which does have standard2.0 bindings, but that does not really translate 1-1 (classes are not there) and there does not seem to be any info online on how to achieve running SSIS from .net core/standard. Anyone managed to do this?</p>