Sign in
Microsoft.com
 
Microsoft
 
 
 

locked
SSIS on Azure SQL RRS feed

 > 

  • Question

  • Question
    Sign in to vote
    0
    Sign in to vote

    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]
@package_name='IMPORT_LPDATA.dtsx',
@execution_id=@execution_id OUTPUT,
@folder_name='TEST',
@project_name='Brazza',
@use32bitruntime=False,
@reference_id=Null
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 ?

    Thanks


    Sunday, November 29, 2020 10:03 AM

All replies

  • Question
    Sign in to vote
    0
    Sign in to vote
    forum migrated to mentioned below link

    https://docs.microsoft.com/en-us/answers/index.html

     hope answer the question if issue resolve please accept answer
    Sunday, November 29, 2020 12:57 PM
  • Question
    Sign in to vote
    0
    Sign in to vote

    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