Post reply

Invoking SSIS remotely using c#

  • 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.).

  • 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.

    If you haven't even tried to resolve your issue, please don't expect the hard-working volunteers here to waste their time providing links to answers which you could easily have found yourself.

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply