i want know if can restrict number of instances running @ same time of same ssis package in ssis catalog bu using c# code. requirement is, want run 4 instances of testpackage.dtsx @ same time asynchronously. tried threading in c# due async execution of ssis package, there remains no limit on executions @ same time causes system hang. please suggest.
you can change execution parameter have package run synchronously:
exec [ssisdb].[catalog].[set_execution_parameter_value] @execution_id -- execution id @object_type=50, -- 50 "execution parameter" @parameter_name=n'synchronized', @parameter_value= 1; -- synchronized execution information on these parameters here: http://www.ssistalk.com/2012/07/24/quick-tip-run-ssis-2012-packages-synchronously-and-other-execution-options/
then manage asnyc calls via c# threading or task.run.
Comments
Post a Comment