Configuration - SQL Server Integration Services Design Patterns - page 418

Listing 17-2 . Running a Package Using T-SQL
-- Create the package execution
DECLARE @exec_id bigint
EXEC [SSISDB].[catalog].[create_execution]
@execution_id=@exec_id OUTPUT,
@package_name=N'LoadCustomers.dtsx',
@folder_name=N'ETL',
@project_name=N'ExecutionDemo',
@use32bitruntime=0
-- Set a new value for the AlwaysCheckForRowDelimiters
property of the
-- SourceFile connection manager
EXEC [SSISDB].[catalog].[set_execution_parameter_value]
@execution_id=@exec_id,
@object_type=20,
@parameter_name=N'CM.SourceFile.AlwaysCheckForRowDelimiters',
@parameter_value=0
-- Set the logging level for this execution
EXEC [SSISDB].[catalog].[set_execution_parameter_value]
@execution_id=@exec_id,
@object_type=50,
@parameter_name=N'LOGGING_LEVEL',
@parameter_value=1
-- Create a property override for the
MaxConcurrentExecutables property
EXEC
[SSISDB].[catalog].[set_execution_property_override_value]
@execution_id=@exec_id,
@property_path=N'\Package.Properties[MaxConcurrentExecutables]',
@property_value=N'1',
@sensitive=0
-- Start the package execution
EXEC [SSISDB].[catalog].[start_execution] @exec_id