DouglasDarbyshire604362

Get Response from SQL into a Automic Variable

Discussion created by DouglasDarbyshire604362 on Jan 22, 2018
Latest reply on Jan 22, 2018 by shravani_vedantham_6826
The following SQL

       USE SSISDB;

       GO

        Declare @execution_id bigint, @environment_id bigint, @etl_status varchar(100)

       EXEC SSISDB.catalog.create_execution

       @package_name=N'TestAutomic.dtsx'

       , @execution_id=@execution_id OUTPUT

       , @folder_name=N'TestAutomic'

       , @project_name=N'TestAutomic'

       , @use32bitruntime=False

       , @reference_id=NULL

      

       EXEC SSISDB.catalog.set_execution_parameter_value

       @execution_id

       , @object_type=50

       , @parameter_name=N'LOGGING_LEVEL'

       , @parameter_value=1

         

       EXEC SSISDB.catalog.start_execution @execution_id;

       SELECT @execution_id

How do i get the execution _id to be a automic variable please provide example

Thanks

Doug

Outcomes