none
SSIS package executed from stored procedure fails with status 6 when using Synchronized RRS feed

  • Question

  • Hello,

    I am executing a SSIS package from a stored procedure. I want to set it to run as synchronized, because I have to return the status of the execution. 

    If I set the synchronized parameter to TRUE, the package ends unexpectedly ( status 6). If I remove the synchronized setting, then everything works fine. 

    Has anyone encountered this issue? 

    DECLARE @var0 smallint = 1
    EXEC [SSISDB].[catalog].[set_execution_parameter_value] 
    @execution_id,  
    @object_type=50, 
    @parameter_name=N'SYNCHRONIZED', 
    @parameter_value=@var0

    Friday, October 18, 2019 11:00 AM

All replies