itmasterw 60042 - Wednesday, February 21, 2018 8:36 AM

Hi,

 I am trying to run a simple FTP package from stored Procedure.
So if I run the package in SSIS it works, that is it moves a file to a server; no problem.
 run the code below and it does not work, but returns in Messages 31089. Not sure if that means anything?
Any thoughts as to what I am doing wrong?
Thank you


create procedure [dbo].[execute_ssis_package_sample]
 @output_execution_id bigint output
as
begin
 declare @execution_id bigint
 exec ssisdb.catalog.create_execution
  @folder_name = 'NightlyPartnerPortalMaintenance'
 ,@project_name = 'TestFTP'
 ,@package_name = 'FTP_Test.dtsx'
 ,@execution_id = @execution_id output
 exec ssisdb.catalog.start_execution @execution_id
 set @output_execution_id = @execution_id
end
GO


And to run it I am doing the following:


declare @output_execution_id bigint
exec dbo.execute_ssis_package_sample @output_execution_id output
print @output_execution_id