asked on

Run SSIS package from Azure File Share using SQL 2019 managed instance agent

I am trying to run a SSIS package from a SQL 2019 Managed Instance using an Azure File Share.

Here is the package in the file share.

Here is how I am trying to create the job in the SQL Agent of the managed instance.

The full package path is

\\xxxxdatabackup.file.core.windows.net\ssispkgs\XXXX API.dtsx

And I put in the account name and key.

When I run the job I get this.

There is no SSISDB so I can't check the internal.operation_messages table.

As for the user, I have no clue what that represents. Seems to be a random value to me.

I did read some stuff that seems to say you have to mount the Azure share to a server but then other people say you can do it like this without mounting.

Has anyone done this and if so what am I doing wrong?

Thanks!

Jim

lcohan

Have you done this:

Before you can deploy and run SSIS packages in Azure, you have to provision the SSIS Catalog (SSISDB) and the Azure-SSIS Integration Runtime.

already? And also please note that:

Note
The Azure-SSIS Integration Runtime is not yet available in all Azure regions. For info about the supported regions, see Products available by region - Microsoft Azure.

All from here: https://docs.microsoft.com/en-us/sql/integration-services/lift-shift/ssis-azure-lift-shift-ssis-packages-overview?view=sql-server-ver15
And details about provisioning SSIS-IR can be found here: https://docs.microsoft.com/en-us/azure/data-factory/how-to-use-sql-managed-instance-with-ir

Jim Youmans

ASKER

I finally ended up using a Azure VM with SQL Server to do this. Thanks.

Jim Youmans

ASKER

I finally ended up using a Azure VM with SQL Server to do this