Share via

Alternative way to Deploy SSIS Package without Data factory

Alternative way for deploying SSIS PackageAzure Db 1 Reputation point
2020-09-13T11:41:51.33+00:00

I need to deploy only few SSIS Package to Azure Database for that I cannot afford the Data factory, is there any Feasible way to deploy the package like using dtex option in Premises Server in Azure

Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
10,677 questions
0 comments

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. HarithaMaddi-MSFT 10,136 Reputation points
    2020-09-14T10:54:09.137+00:00

    Hi @Alternative way for deploying SSIS PackageAzure Db ,

    Welcome to Microsoft Q&A Platform. Thanks for posting the query.

    The current design makes it mandatory to have data factory to create the SSISDB in Azure SQL that is required to deploy packages. This uses Azure-SSIS IR (Integration Runtime) currently as per documentation and hence data factory would be needed as in below snap. Also, the pricing of the data factory is quite reasonable and can be checked with examples in MS document and please check the calculator to look at the pricing estimation.
    24465-limitation.png

    If you think creating data factory is still not feasible as per your requirement, I would recommend you to post the idea in the feedback forum and Azure SQL Product team would be monitoring them and prioritizing the ideas for future implementations.

    Hope this helps! Please let us know for further queries and we will be glad to assist.

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.