File tree

• docs
  • database-engine
    • database-mirroring
      • add-a-database-mirroring-witness-using-windows-authentication-transact-sql.md
      • add-or-replace-a-database-mirroring-witness-sql-server-management-studio.md
      • change-transaction-safety-in-a-database-mirroring-session-transact-sql.md
      • choose-servers-to-configure-configure-database-mirroring-security-wizard.md
      • connect-clients-to-a-database-mirroring-session-sql-server.md
      • create-a-database-mirroring-endpoint-for-windows-authentication-transact-sql.md
      • database-mirroring-allow-network-access-windows-authentication.md
      • database-mirroring-and-database-snapshots-sql-server.md
      • database-mirroring-and-full-text-catalogs-sql-server.md
      • database-mirroring-and-log-shipping-sql-server.md
      • database-mirroring-and-replication-sql-server.md
      • database-mirroring-and-sql-server-failover-cluster-instances.md
      • database-mirroring-establish-session-windows-authentication.md
      • database-mirroring-history.md
      • database-mirroring-interoperability-and-coexistence-sql-server.md
      • database-mirroring-monitor-overview.md
      • database-mirroring-monitor-status-page.md
      • database-mirroring-monitor-warnings-page.md
      • database-mirroring-operating-modes.md
      • database-mirroring-sql-server.md
      • database-mirroring-use-certificates-for-inbound-connections.md
      • database-mirroring-use-certificates-for-outbound-connections.md
      • database-mirroring-witness.md
      • establish-database-mirroring-session-windows-authentication.md
      • estimate-the-interruption-of-service-during-role-switching-database-mirroring.md
      • example-setting-up-database-mirroring-using-certificates-transact-sql.md
      • example-setting-up-database-mirroring-using-windows-authentication-transact-sql.md
      • force-service-in-a-database-mirroring-session-transact-sql.md
      • include-witness-server-configure-database-mirroring-security-wizard.md
      • manually-fail-over-a-database-mirroring-session-sql-server-management-studio.md
      • manually-fail-over-a-database-mirroring-session-transact-sql.md
      • mirror-server-instance-configure-database-mirroring-security-wizard.md
      • mirroring-states-sql-server.md
      • monitoring-database-mirroring-sql-server.md
      • pause-or-resume-a-database-mirroring-session-sql-server.md
      • pausing-and-resuming-database-mirroring-sql-server.md
      • possible-failures-during-database-mirroring.md
      • prepare-a-mirror-database-for-mirroring-sql-server.md
      • prerequisites-restrictions-and-recommendations-for-database-mirroring.md
      • principal-server-instance-configure-database-mirroring-security-wizard.md
      • quorum-how-a-witness-affects-database-availability-database-mirroring.md
      • register-mirrored-database.md
      • remove-database-mirroring-sql-server.md
      • remove-the-witness-from-a-database-mirroring-session-sql-server.md
      • removing-database-mirroring-sql-server.md
      • role-switching-during-a-database-mirroring-session-sql-server.md
      • service-accounts-configure-database-mirroring-security-wizard.md
      • set-up-a-mirror-database-to-use-the-trustworthy-property-transact-sql.md
      • set-up-an-encrypted-mirror-database.md
      • set-up-login-accounts-database-mirroring-always-on-availability.md
      • set-warning-thresholds.md
      • setting-up-database-mirroring-sql-server.md
      • specify-a-server-network-address-database-mirroring.md
      • start-database-mirroring-monitor-sql-server-management-studio.md
      • start-the-configuring-database-mirroring-security-wizard.md
      • the-database-mirroring-endpoint-sql-server.md
      • transport-security-database-mirroring-always-on-availability.md
      • troubleshoot-database-mirroring-configuration-sql-server.md
      • upgrading-mirrored-instances.md
      • use-certificates-for-a-database-mirroring-endpoint-transact-sql.md
      • use-warning-thresholds-and-alerts-on-mirroring-performance-metrics-sql-server.md
      • view-the-state-of-a-mirrored-database-sql-server-management-studio.md
      • witness-server-instance-configure-database-mirroring-security-wizard.md
    • install-windows
      • installing-updates-from-the-command-prompt.md
      • upgrade-master-data-services.md
  • dma
    • new-updated-dma.md
  • dmx
    • new-updated-dmx.md
  • integration-services
    • building-packages-programmatically
      • adding-connections-programmatically.md
      • adding-data-flow-components-programmatically.md
      • adding-tasks-programmatically.md
      • adding-the-data-flow-task-programmatically.md
      • building-packages-programmatically.md
      • connecting-data-flow-components-programmatically.md
      • connecting-tasks-programmatically.md
      • creating-a-package-programmatically.md
      • discovering-data-flow-components-programmatically.md
      • enabling-logging-programmatically.md
      • handling-events-programmatically.md
      • saving-a-package-programmatically.md
      • selecting-input-columns-programmatically.md
      • working-with-variables-programmatically.md
    • catalog
      • browse-all-principals-dialog-box.md
      • configure-dialog-box.md
      • folder-properties-dialog-box.md
      • integration-services-ssis-catalog-transact-sql-reference.md
      • integration-services-ssis-server-and-catalog.md
      • package-properties-dialog-box.md
      • project-properties-dialog-box.md
      • project-versions-dialog-box.md
      • set-parameter-value-dialog-box.md
      • ssis-catalog.md
      • validate-dialog-box.md
      • view-the-list-of-packages-on-the-integration-services-server.md
    • change-data-capture
      • access-the-cdc-designer-console.md
      • add-tables-to-a-cdc-instance.md
      • advanced-connection-properties.md
      • apply-the-changes-to-the-destination.md
      • cdc-instance-deployment-script.md
      • change-data-capture-designer-for-oracle-by-attunity-f1-help-reference.md
      • change-data-capture-designer-for-oracle-by-attunity-how-to-guide.md
      • change-data-capture-designer-for-oracle-by-attunity.md
      • change-data-capture-for-oracle-by-attunity.md
      • change-data-capture-service-for-oracle-by-attunity-f1-help.md
      • change-data-capture-service-for-oracle-by-attunity-how-to-guide.md
      • change-data-capture-service-for-oracle-by-attunity-system-architecture.md
      • change-data-capture-service-for-oracle-by-attunity.md
      • change-data-capture-ssis.md
      • connect-to-an-oracle-source-database.md
      • connect-to-oracle.md
      • connection-to-sql-server-for-delete.md
      • connection-to-sql-server.md
      • create-and-edit-an-oracle-cdc-service.md
      • create-the-function-to-retrieve-the-change-data.md
      • create-the-sql-server-change-database.md
      • determine-whether-the-change-data-is-ready.md
      • edit-instance-properties.md
      • edit-tables.md
      • edit-the-advanced-properties.md
      • edit-the-oracle-database-properties.md
      • edit-the-table-properties.md
      • error-handling.md
      • finish.md
      • generate-and-run-the-supplemental-logging-script.md
      • generate-mirror-tables-and-cdc-capture-instances.md
      • high-availability-support.md
      • how-to-create-and-edit-a-cdc-service.md
      • how-to-create-the-sql-server-change-database-instance.md
      • how-to-edit-the-cdc-instance-properties.md
      • how-to-manage-a-cdc-instance.md
      • how-to-manage-a-cdc-service-from-the-cdc-designer-console.md
      • how-to-manage-a-local-cdc-service.md
      • how-to-prepare-sql-server-for-cdc.md
      • how-to-use-the-cdc-service-command-line-interface.md
      • how-to-view-the-cdc-instance-properties.md
      • how-to-work-with-cdc-services.md
      • make-changes-to-the-tables-selected-for-capturing-changes.md
      • manage-a-cdc-instance.md
      • manage-a-cdc-service.md
      • manage-an-oracle-cdc-service.md
      • oracle-cdc-instance-data-types.md
      • oracle-credentials-for-running-script.md
      • oracle-supplemental-logging-script.md
      • perform-an-incremental-load-of-multiple-tables.md
      • prepare-sql-server-for-cdc.md
      • prepare-sql-server-for-oracle-cdc-view-script.md
      • prepare-to-query-for-the-change-data.md
      • process-inserts-updates-and-deletes.md
      • retrieve-and-understand-the-change-data.md
      • review-and-generate-supplemental-logging-scripts.md
      • select-oracle-tables-and-columns.md
      • select-oracle-tables-for-capturing-changes.md
      • specify-an-interval-of-change-data.md
      • sql-server-connection-for-instance-creation.md
      • sql-server-connection-required-permissions-for-the-cdc-designer.md
      • sql-server-connection-required-permissions-for-the-cdc-service.md
      • the-cdc-designer-console-introduction.md
      • the-oracle-cdc-databases.md
      • the-oracle-cdc-instance.md
      • the-oracle-cdc-service.md
      • use-the-new-instance-wizard.md
      • user-roles.md
      • work-with-cdc-services.md
      • working-with-the-oracle-cdc-service.md
    • connection-manager
      • add-analysis-services-connection-manager-dialog-box-ui-reference.md
      • add-file-connection-manager-dialog-box-ui-reference.md
      • ado-connection-manager.md
      • ado-net-connection-manager.md
      • analysis-services-connection-manager.md
      • azure-data-lake-store-connection-manager.md
      • azure-hdinsight-connection-manager.md
      • azure-resource-manager-connection-manager.md
      • azure-storage-connection-manager.md
      • azure-subscription-connection-manager.md
      • cache-connection-manager.md
      • connect-to-a-dbase-or-other-dbf-file.md
      • connect-to-an-access-database.md
      • connect-to-an-excel-workbook.md
      • data-sources.md
      • dqs-cleansing-connection-manager.md
      • excel-connection-manager.md
      • file-connection-manager.md
      • flat-file-connection-manager.md
      • ftp-connection-manager.md
      • hadoop-connection-manager.md
      • http-connection-manager.md
      • integration-services-ssis-connections.md
      • lookup-transformation-full-cache-mode-cache-connection-manager.md
      • lookup-transformation-full-cache-mode-ole-db-connection-manager.md
      • msmq-connection-manager.md
      • multiple-files-connection-manager.md
      • multiple-flat-files-connection-manager.md
      • odata-connection-manager.md
      • odbc-connection-manager.md
      • ole-db-connection-manager.md
      • sap-bw-connection-manager.md
      • smo-connection-manager.md
      • smtp-connection-manager.md
      • sql-server-compact-edition-connection-manager.md
      • suggest-column-types-dialog-box-ui-reference.md
      • wmi-connection-manager.md
    • control-flow
      • add-or-delete-a-task-or-a-container-in-a-control-flow.md
      • analysis-services-execute-ddl-task.md
      • analysis-services-processing-task.md
      • azure-blob-download-task.md
      • azure-blob-upload-task.md
      • azure-data-lake-store-file-system-task.md
      • azure-hdinsight-create-cluster-task.md
      • azure-hdinsight-delete-cluster-task.md
      • azure-hdinsight-hive-task.md
      • azure-hdinsight-pig-task.md
      • azure-sql-dw-upload-task.md
      • back-up-database-task.md
      • bulk-insert-task.md
      • candidate-key-profile-request-options-data-profiling-task.md
      • cdc-control-task-custom-properties.md
      • cdc-control-task.md
      • check-database-integrity-task.md
      • column-length-distribution-profile-request-options-data-profiling-task.md
      • column-null-ratio-profile-request-options-data-profiling-task.md
      • column-pattern-profile-request-options-data-profiling-task.md
      • column-statistics-profile-request-options-data-profiling-task.md
      • column-value-distribution-profile-request-options-data-profiling-task.md
      • control-flow.md
      • data-flow-task.md
      • data-mining-query-task.md
      • data-mining-query.md
      • data-profile-viewer.md
      • data-profiling-task-and-viewer.md
      • data-profiling-task-editor-general-page.md
      • data-profiling-task-editor-profile-requests-page.md
      • data-profiling-task.md
      • execute-package-task.md
      • execute-process-task.md
      • execute-sql-server-agent-job-task.md
      • execute-sql-task.md
      • execute-t-sql-statement-task.md
      • expression-task.md
      • file-system-task.md
      • for-loop-container.md
      • foreach-loop-container.md
      • ftp-task.md
      • functional-dependency-profile-request-options-data-profiling-task.md
      • hadoop-file-system-task.md
      • hadoop-hive-task.md
      • hadoop-pig-task.md
      • history-cleanup-task.md
      • incorporate-a-data-profiling-task-in-package-workflow.md
      • integration-services-containers.md
      • integration-services-tasks.md
      • loop-through-excel-files-and-tables-by-using-a-foreach-loop-container.md
      • maintenance-cleanup-task.md
      • merge-in-integration-services-packages.md
      • message-queue-task.md
      • notify-operator-task.md
      • precedence-constraints.md
      • rebuild-index-task.md
      • reorganize-index-task.md
      • script-task.md
      • select-a-package.md
      • select-objects-to-transfer.md
      • select-variables-page.md
      • send-mail-task.md
      • sequence-container.md
      • setup-of-the-data-profiling-task.md
      • shrink-database-task.md
      • single-table-quick-profile-form-data-profiling-task.md
      • task-host-container.md
      • transfer-database-task.md
      • transfer-error-messages-task.md
      • transfer-jobs-task.md
      • transfer-logins-task.md
      • transfer-master-stored-procedures-task.md
      • transfer-sql-server-objects-task.md
      • update-statistics-task.md
      • validate-xml-with-the-xml-task.md
      • value-inclusion-profile-request-options-data-profiling-task.md
      • web-service-task.md
      • wmi-data-reader-task.md
      • wmi-event-watcher-task.md
      • xml-task.md
    • data-flow
      • add-or-delete-a-component-in-a-data-flow.md
      • ado-net-custom-properties.md
      • ado-net-destination.md
      • ado-net-source.md
      • azure-blob-destination.md
      • azure-blob-source.md
      • azure-data-lake-store-destination.md
      • azure-data-lake-store-source.md
      • bulk-load-data-by-using-the-sql-server-destination.md
      • cdc-flow-components.md
      • cdc-source-custom-properties.md
      • cdc-source.md
      • cdc-splitter.md
      • comparing-string-data.md
      • connect-components-in-a-data-flow.md
      • create-infocube-for-transaction-data.md
      • create-infopackage.md
      • create-infosource-for-master-data.md
      • create-infosource-for-transaction-data.md
      • create-infosource.md
      • create-new-infoobject.md
      • data-flow-performance-features.md
      • data-flow.md
      • data-in-data-flows.md
      • data-mining-model-training-destination-custom-properties.md
      • data-mining-model-training-destination.md
      • data-streaming-destination.md
      • data-viewer.md
      • datareader-destination-custom-properties.md
      • datareader-destination.md
      • define-a-state-variable.md
      • destination-assistant.md
      • dimension-processing-destination-custom-properies.md
      • dimension-processing-destination.md
      • direct-the-cdc-stream-according-to-the-type-of-change.md
      • error-handling-in-data.md
      • excel-custom-properties.md
      • excel-destination.md
      • excel-source.md
      • extract-change-data-using-the-cdc-source.md
      • extract-data-by-using-the-odbc-source.md
      • extract-data-by-using-the-ole-db-source.md
      • extract-data-by-using-the-xml-source.md
      • flat-file-custom-properties.md
      • flat-file-destination.md
      • flat-file-source.md
      • hdfs-file-destination.md
      • hdfs-file-source.md
      • integration-services-data-types.md
      • integration-services-paths.md
      • load-data-by-using-the-odbc-destination.md
      • load-data-by-using-the-ole-db-destination.md
      • look-up-infoobject.md
      • look-up-infopackage.md
      • look-up-process-chain.md
      • look-up-rfc-destination.md
      • map-query-parameters-to-variables-in-a-data-flow-component.md
      • modify-odata-source-query-at-runtime.md
      • odata-source-properties.md
      • odata-source.md
      • odbc-destination-custom-properties.md
      • odbc-destination.md
      • odbc-flow-components.md
      • odbc-source-custom-properties.md
      • odbc-source.md
      • ole-db-custom-properties.md
      • ole-db-destination.md
      • ole-db-source.md
      • parsing-data.md
      • partition-processing-destination-custom-properties.md
      • partition-processing-destination.md
      • preview.md
      • raw-file-custom-properties.md
      • raw-file-destination.md
      • raw-file-source.md
      • recordset-destination-custom-properties.md
      • recordset-destination.md
      • request-log.md
      • resolve-column-reference-editor.md
      • sap-bw-destination-editor-advanced-page.md
      • sap-bw-destination-editor-connection-manager-page.md
      • sap-bw-destination-editor-error-output-page.md
      • sap-bw-destination-editor-mappings-page.md
      • sap-bw-destination.md
      • sap-bw-source-editor-advanced-page.md
      • sap-bw-source-editor-columns-page.md
      • sap-bw-source-editor-connection-manager-page.md
      • sap-bw-source-editor-error-output-page.md
      • sap-bw-source.md
      • set-the-properties-of-a-data-flow-component.md
      • source-assistant.md
      • sql-server-compact-edition-destination-custom-properties.md
      • sql-server-compact-edition-destination.md
      • sql-server-destination-custom-properties.md
      • sql-server-destination.md
      • transformations
        • aggregate-transformation.md
        • aggregate-values-in-a-dataset-by-using-the-aggregate-transformation.md
        • apply-data-quality-rules-to-data-source.md
        • audit-transformation.md
        • balanced-data-distributor-transformation.md
        • cache-transform.md
        • character-map-transformation.md
        • conditional-split-transformation.md
        • configure-outputs-using-the-slowly-changing-dimension-wizard.md
        • convert-data-type-by-using-data-conversion-transformation.md
        • copy-column-transformation.md
        • create-and-deploy-a-cache-for-the-lookup-transformation.md
        • create-relationships.md
        • data-conversion-transformation.md
        • data-mining-query-transformation.md
        • derive-column-values-by-using-the-derived-column-transformation.md
        • derived-column-transformation.md
        • dqs-cleansing-transformation.md
        • export-column-transformation.md
        • extend-a-dataset-by-using-the-merge-join-transformation.md
        • finish-the-slowly-changing-dimension-wizard.md
        • fixed-and-changing-attribute-options-slowly-changing-dimension-wizard.md
        • fuzzy-grouping-transformation.md
        • fuzzy-lookup-transformation.md
        • historical-attribute-options-slowly-changing-dimension-wizard.md
        • identify-similar-data-rows-by-using-the-fuzzy-grouping-transformation.md
        • implement-a-lookup-in-no-cache-or-partial-cache-mode.md
        • import-column-transformation.md
        • inferred-dimension-members-slowly-changing-dimension-wizard.md
        • integration-services-transformations.md
        • lookup-transformation.md
        • map-columns-to-composite-domains.md
        • merge-data-by-using-the-union-all-transformation.md
        • merge-join-transformation.md
        • merge-transformation.md
        • multicast-transformation.md
        • ole-db-command-transformation.md
        • percentage-sampling-transformation.md
        • pivot-transformation.md
        • row-count-transformation.md
        • row-sampling-transformation.md
        • script-component.md
        • select-a-dimension-table-and-keys-slowly-changing-dimension-wizard.md
        • slowly-changing-dimension-columns-slowly-changing-dimension-wizard.md
        • slowly-changing-dimension-transformation.md
        • slowly-changing-dimension-wizard-f1-help.md
        • sort-data-for-the-merge-and-merge-join-transformations.md
        • sort-transformation.md
        • split-a-dataset-by-using-the-conditional-split-transformation.md
        • term-extraction-transformation.md
        • term-lookup-transformation.md
        • transform-data-with-transformations.md
        • transformation-custom-properties.md
        • union-all-transformation.md
        • unpivot-transformation.md
        • welcome-to-the-slowly-changing-dimension-wizard.md
      • tutorial-using-the-odata-source.md
      • use-a-recordset-destination.md
      • walkthrough-publish-an-ssis-package-as-a-sql-view.md
      • xml-source-custom-properties.md
      • xml-source.md
    • expressions
      • abs-ssis-expression.md
      • add-or-change-a-property-expression.md
      • add-ssis.md
      • bitwise-and-ssis-expression.md
      • bitwise-exclusive-or-ssis-expression.md
      • bitwise-inclusive-or-ssis-expression.md
      • bitwise-not-ssis-expression.md
      • cast-ssis-expression.md
      • ceiling-ssis-expression.md
      • codepoint-ssis-expression.md
      • concatenate-ssis-expression.md
      • conditional-ssis-expression.md
      • data-truncation-ssis.md
      • dateadd-ssis-expression.md
      • datediff-ssis-expression.md
      • datepart-ssis-expression.md
      • day-ssis-expression.md
      • divide-ssis-expression.md
      • enumerated-constants-in-property-expressions.md
      • equal-ssis-expression.md
      • examples-of-advanced-integration-services-expressions.md
      • exp-ssis-expression.md
      • expression-builder.md
      • expressions-page.md
      • findstring-ssis-expression.md
      • floor-ssis-expression.md
      • functions-ssis-expression.md
      • getdate-ssis-expression.md
      • getutcdate-ssis-expression.md
      • greater-than-or-equal-to-ssis-expression.md
      • greater-than-ssis-expression.md
      • hex-ssis-expression.md
      • identifiers-ssis.md
      • integration-services-data-types-in-expressions.md
      • integration-services-ssis-expressions.md
      • isnull-ssis-expression.md
      • left-ssis-expression.md
      • len-ssis-expression.md
      • less-than-or-equal-to-ssis-expression.md
      • less-than-ssis-expression.md
      • ln-ssis-expression.md
      • log-ssis-expression.md
      • logical-and-ssis-expression.md
      • logical-not-ssis-expression.md
      • logical-or-ssis-expression.md
      • lower-ssis-expression.md
      • ltrim-ssis-expression.md
      • modulo-ssis-expression.md
      • month-ssis-expression.md
      • multiply-ssis-expression.md
      • negate-ssis-expression.md
      • null-ssis-expression.md
      • numeric-string-and-boolean-literals.md
      • operator-precedence-and-associativity.md
      • operators-ssis-expression.md
      • parentheses-ssis-expression.md
      • power-ssis-expression.md
      • property-expressions-editor.md
      • replace-ssis-expression.md
      • replacenull-ssis-expression.md
      • replicate-ssis-expression.md
      • reverse-ssis-expression.md
      • right-ssis-expression.md
      • round-ssis-expression.md
      • rtrim-ssis-expression.md
      • sign-ssis-expression.md
      • sqrt-ssis-expression.md
      • square-ssis-expression.md
      • string-padding-ssis.md
      • substring-ssis-expression.md
      • subtract-ssis-expression.md
      • syntax-ssis.md
      • token-ssis-expression.md
      • tokencount-ssis-expression.md
      • trim-ssis-expression.md
      • unequal-ssis-expression.md
      • upper-ssis-expression.md
      • use-property-expressions-in-packages.md
      • year-ssis-expression.md
    • service
      • events-logged-by-the-integration-services-service.md
      • integration-services-service-ssis-service.md
      • integration-services-ssis-in-a-cluster.md
      • package-management-ssis-service.md