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
I haven't tried this way, But I'd tried thru command line.