在没有SQL Server集成服务的情况下运行SSIS包 [英] Run SSIS Package Without SQL Server Integration Services

问题描述

我们可以在没有集成服务的情况下运行SSIS软件包吗?如果是，那么步骤是什么?如果否，那么最低要求是什么.

Can we run SSIS Package without integration services? If Yes then what are the steps? If No then what is the minimum requirement.

问题陈述如下:

我正在使用SQL Azure数据库存储数据.我也有Azure VM，我需要从中计划SSIS程序包.在此Azure VM中，我们没有安装Integration Services.我的方法是使用Windows Scheduler中的批处理文件来计划SSIS包.

I am using SQL Azure database to store the data. I also have Azure VM from which I need to schedule SSIS Packages. In this Azure VM we don't have Integration Services Installed. My approach is to schedule the SSIS package using batch file in windows scheduler.

我已经浏览了各种主题和帖子，但是没有得到正确的答案.

I have gone through various threads and posts regarding this but didn't get the correct answer.

推荐答案

如果不安装SQL Server集成服务，则无法运行SSIS程序包(.dtsx).最低要求是SSIS客户端工具和DTEXEC实用程序，因此您必须从SQL Server安装介质安装Integration Services共享功能.

You cannot run a SSIS package (.dtsx) without installing the SQL Server integration Services. The minimum requirements are the SSIS client tools and the DTEXEC utility so you must install the Integration Services shared feature from the SQL Server install media.

参考

• 执行SSIS包的方式
• 运行未安装SSIS服务的SSIS软件包
• https://www.sqlshack.com/ways-use-execute-sql-server-integration-services-packages/

这篇关于在没有SQL Server集成服务的情况下运行SSIS包的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！