dtutil.exe without SSIS installed

Question

Hi @all ,

let's say I have a bunch of SSIS packages exported from a previous SQL installation I would like to import into a new SQL 2019 server. The dtutil.exe is present on the system but any attempt to invoke it leads to the following error message:

This application requires Integration Services or Database Engine to be installed by SQL Server 2019 Standard, Enterprise, Developer, Business Intelligence, or Evaluation Edition. To install a component, run SQL Server Setup and select the component name.

Database Engine is installed while SSIS is not (and cannot be added because it is a clustered instance). On the SQL 2012 cluster the packages were exported from, SSIS wasn't installed either but dtutil.exe would work without issue. I did a clean install of SQL 2019 in the lab and got the same behaviour: As long as SSIS is not installed, I get this error message.

Is this a known behaviour? Is there a solution, short of installing another SQL server with SSIS just to be able to import packages?

Any help and insight is greatly appreciated!

Stay safe,

Evgenij

Answer 1

Hi @Evgenij Smirnov ,

Based on my test, you need to install SSIS to use dtutil.exe.

In addition, to add SSIS in clustered instance, you may refer below link to see if it is helpful.

https://techcommunity.microsoft.com/t5/sql-server-support-blog/installing-sql-integration-services-after-sql-cluster-setup-has/ba-p/316179

Regards，

Zoe

---

If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

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.

Answer 2

while SSIS is not (and cannot be added because it is a clustered instance).

??? I have 2 cluster running with SSIS installed, so why can't you?
You can not run SSIS package without a running SSIS service.