SQL Integration Services 서비스 시작

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

SQL Integration Services 서비스 시작
모든 SQL Express 버전에서는 기본 제공되는 데이터 원본 커넥터와 함께 SQL Server 가져오기 및 내보내기 마법사만 지원합니다.

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	Microsoft.SQLServer.TaskAccount

Source Code:

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

  <Category>Maintenance</Category>

  <WriteAction ID="WA" TypeID="System!System.CommandExecuter" RunAs="GPMP!Microsoft.SQLServer.TaskAccount">

    <ApplicationName/>

    <WorkingDirectory/>

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

    <TimeoutSeconds>300</TimeoutSeconds>

    <RequireOutput>true</RequireOutput>

    <Files/>

  </WriteAction>

</Task>