SSIS on Azure SQL

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]
@package_name='IMPORT_LPDATA.dtsx',
@execution_id=@execution_id OUTPUT,
@display _name='TEST',
@Shayna Webb _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

Answer 1

Hi @Manuel ,

Please connect to the SSIS Catalog(SSISDB) in Azure in SSMS and then execute the ssis package .

1.Get the connection info from the Azure portal
a. fully qualified server name
b. database name
c. login information

2.Connect with SSMS

Hope the following link will be helpful:
Connect to the SSIS Catalog (SSISDB) in Azure

Best Regards,
Mona

----------

If the answer is helpful, please click "Accept Answer" and upvote it.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.
Hot issues in November--What can I do if my transaction log is full?
Hot issues in November--How to convert Profiler trace into a SQL Server table?

Answer 2

Hello thank you for your answer but I think its not my subject.

I know how to connect a database on a server.

My question is, how I can run a SSIS in stored procedure on my server (1) if my SSISDB is on my server (2) ?

Answer 3

Hello thank you for your answer,

I tried to deploy my package from server (2) to server (1)

I choose my package

but SSMS told me that i don't have SSISDB on my server (1), if I had I will deploy directly on my server (1), so I can't do this

Thanks