1

Is it possible to execute an SSIS package from a Data Factory pipeline where the SSIS packages are deployed to an existing SQL Server instance on a VM also in Azure?

I looked into creating a self-hosted integration runtime but this is only data migration related. Also looked at executing a stored procedure but there is no returned value on success/fail etc.

Thanks

Improve this question

1 Answer 1

Reset to default
0

Spoke to Microsoft and they confirmed you cannot run or trigger SSIS packages that are not hosted in the Azure Integration Runtime. No plans to change that anytime soon.

Improve this answer
Sign up to request clarification or add additional context in comments.

Comments

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.