July 9, 2018 at 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.).
July 9, 2018 at 1:23 pm
amruta.mcs91189 - Monday, July 9, 2018 1:11 PMFor 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.
The absence of evidence is not evidence of absence
- Martin Rees
The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
- Phil Parkin
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply