Guest User

Untitled

a guest
Oct 16th, 2018
79
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.60 KB | None | 0 0
  1. USE SSISDB;
  2. GO
  3.  
  4. CREATE PROCEDURE usp_Execute_Packages
  5.  
  6. AS BEGIN
  7.  
  8. EXECUTE AS LOGIN = 'DomainYourLogin'
  9.  
  10. Declare @execution_id bigint
  11. EXEC [SSISDB].[catalog].[create_execution] @package_name=N'YourPackage.dtsx',
  12. @execution_id=@execution_id OUTPUT, @folder_name=N'Your Folder', @project_name=N'YourProject',
  13. @use32bitruntime=False, @reference_id=Null
  14.  
  15. Select @execution_id
  16.  
  17. DECLARE @var0 smallint = 1
  18. EXEC [SSISDB].[catalog].[set_execution_parameter_value] @execution_id, @object_type=50,
  19. @parameter_name=N'LOGGING_LEVEL', @parameter_value=@var0
  20. EXEC [SSISDB].[catalog].[start_execution] @execution_id
  21.  
  22.  
  23. END
Add Comment
Please, Sign In to add comment