rfsalas

USE [SSISDB]

-- STEP 1: Create an execution instance of the package you want to tap data from
DECLARE	@return_value int,
		@execution_id bigint
EXEC	@return_value = [catalog].[create_execution]
		@folder_name = N'SSISDemo', --Folder in SSIS server where package is deployed
		@project_name = N'SSIS20112 Demo1', --Project in SSIS server where package is deployed
		@package_name = N'Package.dtsx', --Package being executed
		@execution_id = @execution_id OUTPUT