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.

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

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