Invoking SSIS remotely using c#

• amruta.mcs91189

  Grasshopper

  Points: 20

  More actions

  July 9, 2018 at 1:11 pm

  #414337

  For any version of SQL Server I want to use SSIS remotely using c#.Where I can have SQL Server on different machine and SSIS on different machine.Also I want to achieve parallelism while executing the dynamically created SSIS packages(.dtxs.).

• Phil Parkin

  SSC Guru

  Points: 247172

  More actions

  July 9, 2018 at 1:23 pm

  #1996854

  amruta.mcs91189 - Monday, July 9, 2018 1:11 PM

  For any version of SQL Server I want to use SSIS remotely using c#.Where I can have SQL Server on different machine and SSIS on different machine.Also I want to achieve parallelism while executing the dynamically created SSIS packages(.dtxs.).

  I'm guessing your question here...

  The easiest way I can think of doing this is 

  1) Deploying your packages to SSISDB (needed for step (2))
  2) Writing a stored proc to execute SSIS packages (on the SQL instance where SSIS is running)
  3) Use C# to call the stored proc & do your multithreading by calling the proc from C#, in parallel, with different parameters.

  ---