Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- USE SSISDB;
- GO
- CREATE PROCEDURE usp_Execute_Packages
- AS BEGIN
- EXECUTE AS LOGIN = 'DomainYourLogin'
- Declare @execution_id bigint
- EXEC [SSISDB].[catalog].[create_execution] @package_name=N'YourPackage.dtsx',
- @execution_id=@execution_id OUTPUT, @folder_name=N'Your Folder', @project_name=N'YourProject',
- @use32bitruntime=False, @reference_id=Null
- Select @execution_id
- DECLARE @var0 smallint = 1
- EXEC [SSISDB].[catalog].[set_execution_parameter_value] @execution_id, @object_type=50,
- @parameter_name=N'LOGGING_LEVEL', @parameter_value=@var0
- EXEC [SSISDB].[catalog].[start_execution] @execution_id
- END
Add Comment
Please, Sign In to add comment