Editar

Compartir a través de

Add an SSIS node to an existing environment

  • Artículo

This article explains how to add a Microsoft SQL Server Integration Services (SSIS) node in an on-premises environment. SSIS nodes were introduced in version 10.0.32 (Platform update 56) and are used by the Data management framework.

Installation steps

  1. Confirm that your environment is on version 10.0.32 (Platform update 56) or later.

  2. Download and extract the latest setup scripts from Microsoft Dynamics Lifecycle Services. For more information, see Download the infrastructure scripts.

    Important

    The scripts must be run from a computer that's in the same domain as the on-premises infrastructure.

  3. Update the infrastructure scripts. For more information, see Update the infrastructure scripts.

  4. In the ConfigTemplate.xml file, in the SSISNodeType section, modify the SSIS nodes. Confirm that the disabled parameter is set to false.

    <NodeType name="SSISNodeType" primary="false" namePrefix="SSIS" purpose="SSIS" disabled="false">
    <!-- Do not place hasSSIS on this node type. -->
    <VMList>
        <VM name="ssis1" ipAddress="10.179.108.22" faultDomain="fd:/fd0" updateDomain="ud0" />
        <VM name="ssis2" ipAddress="10.179.108.23" faultDomain="fd:/fd1" updateDomain="ud1" />
    </VMList>
</NodeType>

  5. Create the Data import/export framework (DIXF) group managed service account (gMSA). For more information, see Step 8. Create gMSAs. Option 1 creates just the new DIXF gMSA.

  6. Run the following script to create the file share.

    .\New-FileShares.ps1 -ConfigurationFilePath .\ConfigTemplate.xml -FileShareReference "dixf"

  7. Run the following script to apply the required configuration and permissions to each file share.

    .\Configure-FileShares.ps1 -ConfigurationFilePath .\ConfigTemplate.xml -FileShareReference "dixf"
.\Configure-FileShares.ps1 -ConfigurationFilePath .\ConfigTemplate.xml -FileShareReference "aos"

  8. Install SSIS on the required nodes. For more information, see Step 12. Set up SSIS.

  9. Follow the instructions in Add a node to an existing environment to add the new node to the environment.

  10. If your environment was originally deployed before version 10.0.32, you must add the predeployment script to enable the DIXF service. If you don't have the base predeployment script, set up the script, and enable the TSG_EnableDixfService.ps1 script. In the main predeployment script, uncomment the line for the DIXF script, and confirm that the DIXF share that you created in the previous step is set. For more information, see Scripts for resolving issues in on-premises environments.

  11. Sign in to Lifecycle Services, and select the project and environment. Select Maintain > Update settings, and then select Prepare. After the configuration is downloaded, select Update in Lifecycle Services to complete the process.