CODEWITHSUNDEEP
sql-serverazuressisazure-sql-database
Sandeep Gupta
Sandeep Gupta

Reputation: 127

dtexec.exe without full SQL Server

I know that Azure SQL Database does not have SQL Server Agent to run SQL jobs. I can run the SSIS package through command prompt. I can create & run SSIS package through SSDT with no restriction but same package if I want to run on server through command line I need dtexec.exe. How same package runs with SSDT without SQL Server?

Can I have dtexec.exe without installing full version of SQL Server? I can't afford SQL Server license for Prod server.

Upvotes: 0

Views: 2018

Answers (1)

steoleary
steoleary

Reputation: 9278

To execute SSIS packages using dtexec or any other method requires a full SQL Server license for the server that you are running them on. Although SQL Server components can be split out, you still need a full license for every server you install them to.

Upvotes: 3

Related Questions