Arrêter le service SQL Integration Services

Microsoft.SQLServer.2016.IntegrationServices.StopService (Task)

Arrêter le service SQL Integration Services
Toutes les éditions de SQL Express prennent uniquement en charge l’Assistant Importation et Exportation SQL Server, ainsi que les connecteurs de source de données intégrés.

Element properties:

Target	Microsoft.SQLServer.2016.IntegrationServices.Instance
Accessibility	Internal
Category	Maintenance
Enabled	True
Remotable	False
Timeout	300

Member Modules:

ID	Module Type	TypeId	RunAs
WA	WriteAction	System.CommandExecuter	Default

Source Code:

<Task ID="Microsoft.SQLServer.2016.IntegrationServices.StopService" Target="SQL2016IS!Microsoft.SQLServer.2016.IntegrationServices.Instance" Accessibility="Internal" Enabled="true" Remotable="false">

  <Category>Maintenance</Category>

  <WriteAction ID="WA" TypeID="System!System.CommandExecuter">

    <ApplicationName/>

    <WorkingDirectory/>

    <CommandLine>net stop $Target/Property[Type="SQL2016IS!Microsoft.SQLServer.2016.IntegrationServices.Instance"]/ServiceName$ /y</CommandLine>

    <TimeoutSeconds>300</TimeoutSeconds>

    <RequireOutput>true</RequireOutput>

    <Files/>

  </WriteAction>

</Task>