问题描述
您好
我正在尝试将维护计划导入到只安装了SQL引擎的新服务器
I am trying to import maintenances plans to a new server with only SQL engine insalled
dtutil / FILE SSISpackageFile。 dtx / DESTSERVER ....
dtutil /FILE SSISpackageFile.dtx /DESTSERVER ....
抛出此错误
此应用程序需要SQL Server 2016 Standard安装Integration Services或Database Engine，企业，开发人员，商业智能或评估版。要安装组件，请运行SQL Server安装程序并选择组件名称。
This application requires Integration Services or Database Engine to be installed by SQL Server 2016 Standard, Enterprise, Developer, Business Intelligence, or Evaluation Edition. To install a component, run SQL Server Setup and select the component name.
我可以在不安装SSIS组件的情况下使用dtutil吗？
Can I use dtutil without installling SSIS componenent ?
环境：SQL 2016 SE SP2
Env : SQL 2016 SE SP2
祝你好运
推荐答案
即使用dtutil导入维护计划，我认为它们不会起作用没有安装SSIS。
Even after importing maintenance plans with dtutil, I don't think they will function without SSIS installed.
如果您不想安装SSIS，另一个实现数据库维护的选项是使用脚本化解决方案，例如
。这种方法实际上是由许多有经验的DBA使用和推荐的。
If you don't want to install SSIS, another option to achieve database maintenance is with a scripted solution, likeOla Hallengren's maintenance solution. This approach is actually used and recommended by many experienced DBA's.
HTH，
这篇关于使用dtutil导入维护计划的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持！