SSIS on Azure SQL RRS feed

  • Question

  • Hello I would like to execute SSIS package ona SQL azure server but SSISDB is on a different server

    I would like to execute my SSIS on database (1) but my SSIS is on server (2)

    When I execute this code on server (2) it works :

    Declare @execution_id bigint
    EXEC [SSISDB].[catalog].[create_execution]
    @execution_id=@execution_id OUTPUT,
    EXEC [SSISDB].[catalog].[start_execution] @execution_id

    I would like now to execute my SSIS on server (1), it is possible . How can I do it ?


    Sunday, November 29, 2020 10:03 AM

All replies

  • forum migrated to mentioned below link


     hope answer the question if issue resolve please accept answer
    Sunday, November 29, 2020 12:57 PM
  • Hi MANUEL1980,
    This form mainly discusses about Linq to sql.
    For questions about SSIS, I suggest you ask the question on the Microsoft Q&A forum and you can get more professional answer.
    Thank you for your understanding.
    Best Regards,
    Daniel Zhang

    "Visual c#" forum will be migrating to a new home on Microsoft Q&A ! We invite you to post new questions in the "Developing Universal Windows apps" forum’s new home on Microsoft Q&A ! For more information, please refer to the sticky post.

    Monday, November 30, 2020 5:35 AM