File tree

• docs
  • connect
    • php
      • direct-statement-execution-prepared-statement-execution-pdo-sqlsrv-driver.md
      • formatting-decimals-pdo-sqlsrv-driver.md
      • formatting-decimals-sqlsrv-driver.md
      • handling-errors-and-warnings.md
      • how-to-configure-error-and-warning-handling-using-the-sqlsrv-driver.md
      • how-to-disable-multiple-active-resultsets-mars.md
      • how-to-handle-errors-and-warnings-using-the-sqlsrv-driver.md
      • how-to-perform-transactions.md
      • how-to-retrieve-binary-data-as-a-stream-using-the-sqlsrv-driver.md
      • how-to-retrieve-character-data-as-a-stream-using-the-sqlsrv-driver.md
      • how-to-retrieve-datetime-objects-using-pdo-sqlsrv-driver.md
      • how-to-retrieve-input-and-output-parameters-using-the-sqlsrv-driver.md
      • how-to-send-and-retrieve-ascii-data-in-linux-mac.md
      • how-to-specify-parameter-direction-using-the-sqlsrv-driver.md
      • how-to-specify-php-data-types.md
      • how-to-specify-sql-server-data-types-when-using-the-sqlsrv-driver.md
      • logging-activity.md
      • non-system-locale-settings.md
      • pdo-begintransaction.md
      • pdo-class.md
      • pdo-commit.md
      • pdo-construct.md
      • pdo-errorcode.md
      • pdo-errorinfo.md
      • pdo-exec.md
      • pdo-getattribute.md
      • pdo-getavailabledrivers.md
      • pdo-lastinsertid.md
      • pdo-quote.md
      • pdo-rollback.md
      • pdo-setattribute.md
      • pdostatement-bindcolumn.md
      • pdostatement-bindparam.md
      • pdostatement-bindvalue.md
      • pdostatement-class.md
      • pdostatement-closecursor.md
      • pdostatement-columncount.md
      • pdostatement-debugdumpparams.md
      • pdostatement-errorcode.md
      • pdostatement-errorinfo.md
      • pdostatement-execute.md
      • pdostatement-fetch.md
      • pdostatement-fetchall.md
      • pdostatement-fetchcolumn.md
      • pdostatement-fetchobject.md
      • pdostatement-getattribute.md
      • pdostatement-getcolumnmeta.md
      • pdostatement-nextrowset.md
      • pdostatement-rowcount.md
      • pdostatement-setattribute.md
      • pdostatement-setfetchmode.md
      • php-driver-for-sql-server-support-for-high-availability-disaster-recovery.md
      • retrieving-data-as-a-stream-using-the-sqlsrv-driver.md
      • retrieving-data.md
      • security-considerations-for-php-sql-driver.md
      • specifying-a-cursor-type-and-selecting-rows.md
      • sqlsrv-begin-transaction.md
      • sqlsrv-cancel.md
      • sqlsrv-close.md
      • sqlsrv-commit.md
      • sqlsrv-configure.md
      • sqlsrv-execute.md
      • sqlsrv-fetch-object.md
      • sqlsrv-fetch.md
      • sqlsrv-field-metadata.md
      • sqlsrv-free-stmt.md
      • sqlsrv-get-config.md
      • sqlsrv-get-field.md
      • sqlsrv-has-rows.md
      • sqlsrv-next-result.md
      • sqlsrv-num-fields.md
      • sqlsrv-rollback.md
      • sqlsrv-rows-affected.md
      • sqlsrv-send-stream-data.md
      • sqlsrv-server-info.md
      • updating-data-microsoft-drivers-for-php-for-sql-server.md
      • using-always-encrypted-php-drivers.md
      • using-directional-parameters.md
    • ruby
      • step-2-create-a-sql-database-for-ruby-development.md
      • step-3-proof-of-concept-connecting-to-sql-using-ruby.md
  • data-quality-services
    • adding-knowledge-to-a-knowledge-base.md
    • backing-up-and-restoring-dqs-databases.md
    • building-a-knowledge-base.md
    • change-domain-values.md
    • cleanse-data-in-a-composite-domain.md
    • cleanse-data-using-dqs-internal-knowledge.md
    • configure-advanced-settings-for-dqs-log-files.md
    • configure-dqs-to-use-reference-data.md
    • configure-severity-levels-for-dqs-log-files.md
    • create-a-composite-domain.md
    • create-a-cross-domain-rule.md
    • create-a-data-quality-project.md
    • create-a-domain-rule.md
    • create-a-domain.md
    • create-a-knowledge-base.md
    • create-a-linked-domain.md
    • create-a-matching-policy.md
    • create-term-based-relations.md
    • data-cleansing.md
    • data-matching.md
    • data-profiling-and-notifications-in-dqs.md
    • data-quality-client-application.md
    • data-quality-client-home-screen.md
    • data-quality-projects-dqs.md
    • data-quality-services-concepts.md
    • data-quality-services-features-and-tasks.md
    • data-quality-services.md
    • detaching-and-attaching-dqs-databases.md
    • domain-management-domain-list.md
    • dqs-administration.md
    • dqs-knowledge-bases-and-domains.md
    • dqs-security.md
    • enable-or-disable-profiling-notifications-in-dqs.md
    • export-a-domain-to-a-dqs-file.md
    • export-a-knowledge-base-to-a-dqs-file.md
    • import-a-domain-from-a-dqs-file.md
    • import-a-knowledge-base-from-a-dqs-file.md
    • import-cleansing-project-values-into-a-domain.md
    • import-values-from-an-excel-file-into-a-domain.md
    • importing-and-exporting-knowledge.md
    • install-windows
      • access-data-for-the-dqs-operations.md
      • grant-dqs-roles-to-users.md
      • install-data-quality-services.md
    • introduction-to-data-quality-services.md
    • manage-a-knowledge-base.md
    • manage-dqs-databases.md
    • manage-dqs-log-files.md
    • managing-a-composite-domain.md
    • managing-a-domain.md
    • monitor-dqs-activities.md
    • open-a-knowledge-base.md
    • perform-knowledge-discovery.md
    • reference-data-services-in-dqs.md
    • run-a-matching-project.md
    • run-the-data-quality-client-application.md
    • set-domain-properties.md
    • use-the-dqs-speller.md
    • use-value-relations-in-a-composite-domain.md
    • using-the-dqs-default-knowledge-base.md
  • database-engine
    • availability-groups/windows
      • transactions-always-on-availability-and-database-mirroring.md
    • configure-windows
      • suppress-recovery-model-errors-server-configuration-option.md
    • database-mirroring
      • use-certificates-for-a-database-mirroring-endpoint-transact-sql.md
    • deprecated-database-engine-features-in-sql-server-version-15.md
    • install-windows
      • latest-updates-for-microsoft-sql-server.md
      • repair-a-failed-sql-server-installation.md
      • upgrade-analysis-services.md
      • upgrade-power-pivot-for-sharepoint.md
  • dmx
    • add-dmx.md
    • alter-mining-structure-dmx.md
    • and-dmx.md
    • bottomcount-dmx.md
    • bottompercent-dmx.md
    • bottomsum-dmx.md
    • cluster-dmx.md
    • clusterdistance-dmx.md
    • clusterprobability-dmx.md
    • comment-dmx-summary.md
    • comments-dmx.md
    • content-types-dmx.md
    • create-mining-model-dmx.md
    • create-mining-structure-dmx.md
    • data-mining-extensions-dmx-function-reference.md
    • data-mining-extensions-dmx-operator-reference.md
    • data-mining-extensions-dmx-reference.md
    • data-mining-extensions-dmx-statements.md
    • data-mining-extensions-dmx-syntax-conventions.md
    • data-mining-extensions-dmx-syntax-elements.md
    • data-types-dmx.md
    • delete-dmx.md
    • distributions-dmx.md
    • divide-dmx.md
    • dmx-statements-data-definition.md
    • dmx-statements-data-manipulation.md
    • dmx-tutorials-analysis-services-data-mining.md
    • double-slash-comment-dmx.md
    • drop-mining-model-dmx.md
    • drop-mining-structure-dmx.md
    • equal-to-dmx.md
    • exists-dmx.md
    • export-dmx.md
    • expressions-dmx.md
    • functions-dmx.md
    • general-prediction-functions-dmx.md
    • greater-than-dmx.md
    • greater-than-or-equal-to-dmx.md
    • identifiers-dmx.md
    • import-dmx.md
    • insert-into-dmx.md
    • isdescendant-dmx.md
    • isinnode-dmx.md
    • istestcase-dmx.md
    • istrainingcase-dmx.md
    • lag-dmx.md
    • less-than-dmx.md
    • less-than-or-equal-to-dmx.md
    • modeling-flags-dmx.md
    • multiply-dmx.md
    • negative-dmx.md
    • not-dmx.md
    • not-equal-to-dmx.md
    • operators-arithmetic.md
    • operators-comparison.md
    • operators-dmx.md
    • operators-logical.md
    • operators-unary.md
    • or-dmx.md
    • positive-dmx.md
    • predict-dmx.md
    • predictadjustedprobability-dmx.md
    • predictassociation-dmx.md
    • predictcaselikelihood-dmx.md
    • predicthistogram-dmx.md
    • predictnodeid-dmx.md
    • predictprobability-dmx.md
    • predictsequence-dmx.md
    • predictstdev-dmx.md
    • predictsupport-dmx.md
    • predicttimeseries-dmx.md
    • predictvariance-dmx.md
    • rangemax-dmx.md
    • rangemid-dmx.md
    • rangemin-dmx.md
    • reserved-keywords-dmx.md
    • select-distinct-from-model-dmx.md
    • select-dmx.md
    • select-from-model-cases-dmx.md
    • select-from-model-content-dmx.md
    • select-from-model-dimension-content-dmx.md
    • select-from-model-dmx.md
    • select-from-model-prediction-join-dmx.md
    • select-from-model-sample-cases-dmx.md
    • select-from-structure-cases.md
    • select-into-dmx.md
    • slash-star-comment-dmx.md
    • source-data-query-openquery.md
    • source-data-query-openrowset.md
    • source-data-query-shape.md
    • source-data-query.md
    • structure-and-usage-of-dmx-prediction-queries.md
    • structurecolumn-dmx.md
    • subtract-dmx.md
    • topcount-dmx.md
    • toppercent-dmx.md
    • topsum-dmx.md
    • understanding-the-dmx-select-statement.md
    • update-dmx.md
    • usage-dmx.md
  • integration-services
    • add-copy-of-existing-package.md
    • advanced-editor.md
    • attunity-connectors.md
    • azure-feature-pack-for-integration-services-ssis.md
    • 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
    • certification-by-sap.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
      • known-issues-resolutions-with-cdc-for-oracle-attunity.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
      • analysis-services-connection-manager.md
      • azure-data-lake-store-connection-manager.md
      • azure-hdinsight-connection-manager.md
      • azure-resource-manager-connection-manager.md
      • azure-subscription-connection-manager.md
      • cache-connection-manager.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
      • 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
      • flexible-file-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
    • copy-a-package-in-sql-server-data-tools.md
    • copy-package-objects.md
    • create-packages-in-sql-server-data-tools.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
      • flexible-file-destination.md
      • flexible-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
      • oracle-connection-manager.md
      • oracle-connector.md
      • oracle-data-type-support.md
      • oracle-destination.md
      • oracle-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
      • teradata-connection-manager.md
      • teradata-connector.md
      • teradata-data-type-support.md
      • teradata-destination.md
      • teradata-source.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
    • delete-packages.md
    • deploy-packages-with-ssis.md
    • dtutil-utility.md
    • errors-and-events-reference-integration-services.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
    • extending-packages-custom-objects-data-flow-types
      • developing-a-custom-destination-component.md
      • developing-a-custom-source-component.md
      • developing-a-custom-transformation-component-with-asynchronous-outputs.md
      • developing-a-custom-transformation-component-with-synchronous-outputs.md
      • developing-data-flow-components-with-multiple-inputs.md
      • developing-specific-types-of-data-flow-components.md
    • extending-packages-custom-objects
      • building-deploying-and-debugging-custom-objects.md
      • connection-manager
        • coding-a-custom-connection-manager.md
        • creating-a-custom-connection-manager.md
        • developing-a-custom-connection-manager.md
        • developing-a-user-interface-for-a-custom-connection-manager.md
      • data-flow
        • creating-a-custom-data-flow-component.md
        • design-time-methods-of-a-data-flow-component.md
        • developing-a-custom-data-flow-component.md
        • developing-a-user-interface-for-a-data-flow-component.md
        • execution-plan-and-buffer-allocation.md
        • implementing-external-metadata.md
        • logging-and-defining-log-entries-in-a-data-flow-component.md
        • raising-and-defining-events-in-a-data-flow-component.md
        • run-time-methods-of-a-data-flow-component.md
        • upgrading-the-version-of-a-data-flow-component.md
        • using-error-outputs-in-a-data-flow-component.md
        • validating-a-data-flow-component.md
        • working-with-data-types-in-the-data-flow.md
      • developing-custom-objects-for-integration-services.md
      • extending-packages-with-custom-objects.md
      • foreach-enumerator
        • coding-a-custom-foreach-enumerator.md
        • creating-a-custom-foreach-enumerator.md
        • developing-a-custom-foreach-enumerator.md
        • developing-a-user-interface-for-a-custom-foreach-enumerator.md
      • log-provider
        • coding-a-custom-log-provider.md
        • creating-a-custom-log-provider.md
        • developing-a-custom-log-provider.md
        • developing-a-user-interface-for-a-custom-log-provider.md
      • persisting-custom-objects.md
      • support-multi-targeting-in-your-custom-components.md
      • task
        • adding-support-for-debugging-in-a-custom-task.md
        • coding-a-custom-task.md
        • connecting-to-data-sources-in-a-custom-task.md
        • creating-a-custom-task.md
        • developing-a-custom-task.md
        • developing-a-user-interface-for-a-custom-task.md
        • raising-and-defining-events-in-a-custom-task.md
    • extending-packages-scripting-data-flow-script-component-examples
      • additional-script-component-examples.md
      • creating-an-odbc-destination-with-the-script-component.md
      • enhancing-an-error-output-with-the-script-component.md
      • parsing-non-standard-text-file-formats-with-the-script-component.md
      • simulating-an-error-output-for-the-script-component.md
    • extending-packages-scripting-data-flow-script-component-types
      • creating-a-destination-with-the-script-component.md
      • creating-a-source-with-the-script-component.md
      • creating-a-synchronous-transformation-with-the-script-component.md
      • creating-an-asynchronous-transformation-with-the-script-component.md
      • developing-specific-types-of-script-components.md
    • extending-packages-scripting-task-examples
      • detecting-an-empty-flat-file-with-the-script-task.md
      • finding-installed-printers-with-the-script-task.md
      • gathering-a-list-for-the-foreach-loop-with-the-script-task.md
      • monitoring-performance-counters-with-the-script-task.md
      • querying-the-active-directory-with-the-script-task.md
      • script-task-examples.md
      • sending-an-html-mail-message-with-the-script-task.md
      • sending-to-a-remote-private-message-queue-with-the-script-task.md
      • working-with-excel-files-with-the-script-task.md
      • working-with-images-with-the-script-task.md
    • extending-packages-scripting
      • comparing-scripting-solutions-and-custom-objects.md
      • comparing-the-script-task-and-the-script-component.md
      • data-flow-script-component
        • coding-and-debugging-the-script-component.md
        • configuring-the-script-component-in-the-script-component-editor.md
        • connecting-to-data-sources-in-the-script-component.md
        • extending-the-data-flow-with-the-script-component.md
        • logging-in-the-script-component.md
        • raising-events-in-the-script-component.md
        • understanding-the-script-component-object-model.md
        • using-variables-in-the-script-component.md
      • debug-a-script-by-setting-breakpoints-in-a-script-task-and-script-component.md
      • extending-packages-with-scripting.md
      • referencing-other-assemblies-in-scripting-solutions.md
      • task
        • coding-and-debugging-the-script-task.md
        • configuring-the-script-task-in-the-script-task-editor.md
        • connecting-to-data-sources-in-the-script-task.md
        • extending-the-package-with-the-script-task.md
        • logging-in-the-script-task.md
        • raising-events-in-the-script-task.md
        • returning-results-from-the-script-task.md
        • using-variables-in-the-script-task.md
    • functions-dm-execution-performance-counters.md
    • general-page-of-integration-services-designers-options.md
    • group-or-ungroup-components.md
    • hadoop-and-hdfs-support-in-integration-services-ssis.md
    • import-export-data
      • choose-a-data-source-sql-server-import-and-export-wizard.md
      • choose-a-destination-sql-server-import-and-export-wizard.md
      • column-conversion-details-dialog-box-sql-server-import-and-export-wizard.md
      • column-mappings-sql-server-import-and-export-wizard.md
      • complete-the-wizard-sql-server-import-and-export-wizard.md
      • configure-flat-file-destination-sql-server-import-and-export-wizard.md
      • connect-to-a-flat-file-data-source-sql-server-import-and-export-wizard.md
      • connect-to-a-mysql-data-source-sql-server-import-and-export-wizard.md
      • connect-to-a-postgresql-data-source-sql-server-import-and-export-wizard.md
      • connect-to-a-sql-server-data-source-sql-server-import-and-export-wizard.md
      • connect-to-an-access-data-source-sql-server-import-and-export-wizard.md
      • connect-to-an-excel-data-source-sql-server-import-and-export-wizard.md
      • connect-to-an-oracle-data-source-sql-server-import-and-export-wizard.md
      • connect-to-azure-blob-storage-sql-server-import-and-export-wizard.md
      • connect-to-data-sources-with-the-sql-server-import-and-export-wizard.md
      • convert-types-without-conversion-checking-sql-server-import-and-export-wizard.md
      • create-database-sql-server-import-and-export-wizard.md
      • create-table-sql-statement-sql-server-import-and-export-wizard.md
      • data-type-mapping-in-the-sql-server-import-and-export-wizard.md
      • get-started-with-this-simple-example-of-the-import-and-export-wizard.md
      • import-and-export-data-with-the-sql-server-import-and-export-wizard.md
      • performing-operation-sql-server-import-and-export-wizard.md
      • preview-data-dialog-box-sql-server-import-and-export-wizard.md
      • provide-a-source-query-sql-server-import-and-export-wizard.md
      • review-data-type-mapping-sql-server-import-and-export-wizard.md
      • save-and-run-package-sql-server-import-and-export-wizard.md
      • save-ssis-package-sql-server-import-and-export-wizard.md
      • select-source-tables-and-views-sql-server-import-and-export-wizard.md
      • specify-table-copy-or-query-sql-server-import-and-export-wizard.md
      • start-the-sql-server-import-and-export-wizard.md
      • steps-in-the-sql-server-import-and-export-wizard.md
      • welcome-to-sql-server-import-and-export-wizard.md
    • install-windows
      • installing-integration-services-versions-side-by-side.md
      • upgrade-integration-services-packages-using-the-ssis-package-upgrade-wizard.md
      • upgrade-integration-services-packages.md
      • upgrade-integration-services.md
    • installing-the-microsoft-connector-for-sap-bw.md
    • integration-services-backward-compatibility.md
    • integration-services-developer-documentation.md
    • integration-services-error-and-message-reference.md
    • integration-services-features-supported-by-the-editions-of-sql-server.md
    • integration-services-language-reference.md
    • integration-services-programming-overview.md
    • integration-services-ssis-development-and-management-tools.md
    • integration-services-ssis-event-handlers.md
    • integration-services-ssis-package-and-project-parameters.md
    • integration-services-ssis-packages.md
    • integration-services-ssis-projects-and-solutions.md
    • integration-services-ssis-queries.md
    • integration-services-ssis-variables.md
    • integration-services-transactions.md
    • integration-services-tutorials.md
    • integration-services-user-interface.md
    • lesson-1-1-creating-a-new-integration-services-project.md
    • lesson-1-1-creating-working-folders-and-environment-variables.md
    • lesson-1-2-adding-and-configuring-a-flat-file-connection-manager.md
    • lesson-1-2-creating-the-deployment-project.md
    • lesson-1-3-adding-and-configuring-an-ole-db-connection-manager.md
    • lesson-1-3-adding-packages-and-other-files.md
    • lesson-1-4-adding-a-data-flow-task-to-the-package.md
    • lesson-1-4-adding-package-configurations.md
    • lesson-1-5-adding-and-configuring-the-flat-file-source.md
    • lesson-1-5-testing-the-updated-packages.md
    • lesson-1-6-adding-and-configuring-the-lookup-transformations.md
    • lesson-1-7-adding-and-configuring-the-ole-db-destination.md
    • lesson-1-8-making-the-lesson-1-package-easier-to-understand.md
    • lesson-1-9-testing-the-lesson-1-tutorial-package.md
    • lesson-1-create-a-project-and-basic-package-with-ssis.md
    • lesson-1-preparing-to-create-the-deployment-bundle.md
    • lesson-2-1-building-the-deployment-utility.md
    • lesson-2-1-copying-the-lesson-1-package.md
    • lesson-2-2-adding-and-configuring-the-foreach-loop-container.md
    • lesson-2-2-verifying-the-deployment-bundle.md
    • lesson-2-3-modifying-the-flat-file-connection-manager.md
    • lesson-2-4-testing-the-lesson-2-tutorial-package.md
    • lesson-2-adding-looping-with-ssis.md
    • lesson-2-create-the-deployment-bundle-in-ssis.md
    • lesson-3-1-copying-the-deployment-bundle.md
    • lesson-3-1-copying-the-lesson-2-package.md
    • lesson-3-2-adding-and-configuring-logging.md
    • lesson-3-2-running-the-package-installation-wizard.md
    • lesson-3-3-testing-the-deployed-packages.md
    • lesson-3-3-testing-the-lesson-3-tutorial-package.md
    • lesson-3-add-logging-with-ssis.md
    • lesson-3-install-ssis-packages.md
    • lesson-4-1-copying-the-lesson-3-package.md
    • lesson-4-2-creating-a-corrupted-file.md
    • lesson-4-3-adding-error-flow-redirection.md
    • lesson-4-4-adding-a-flat-file-destination.md
    • lesson-4-5-testing-the-lesson-4-tutorial-package.md
    • lesson-4-add-error-flow-redirection-with-ssis.md
    • lesson-5-1-copying-the-lesson-4-package.md
    • lesson-5-2-enabling-and-configuring-package-configurations.md
    • lesson-5-3-modifying-the-directory-property-configuration-value.md
    • lesson-5-4-testing-the-lesson-5-tutorial-package.md
    • lesson-5-add-ssis-package-configurations-for-the-package-deployment-model.md
    • lesson-6-1-copying-the-lesson-5-package.md
    • lesson-6-2-converting-the-project-to-the-project-deployment-model.md
    • lesson-6-3-testing-the-lesson-6-package.md
    • lesson-6-4-deploying-the-lesson-6-package.md
    • lesson-6-using-parameters-with-the-project-deployment-model-in-ssis.md
    • microsoft-connector-for-sap-bw-components.md
    • microsoft-connector-for-sap-bw-f1-help.md
    • microsoft-connector-for-sap-bw.md
    • packages
      • deploy-integration-services-ssis-projects-and-packages.md
      • dtexec-utility.md
      • execute-package-utility-dtexecui-ui-reference.md
      • legacy-package-deployment-ssis.md
      • load-balancing-packages-on-remote-servers-by-using-sql-server-agent.md
      • restart-packages-by-using-checkpoints.md
      • run-integration-services-ssis-packages.md
      • sql-server-agent-jobs-for-packages.md
    • performance
      • events-logged-by-an-integration-services-package.md
      • integration-services-ssis-logging.md
      • monitor-running-packages-and-other-operations.md
      • performance-counters.md
    • reuse-control-flow-across-packages-by-using-control-flow-package-parts.md
    • reuse-of-package-objects.md
    • run-manage-packages-programmatically
      • enumerating-available-packages-programmatically.md
      • loading-and-running-a-local-package-programmatically.md
      • loading-and-running-a-remote-package-programmatically.md
      • loading-the-output-of-a-local-package.md
      • managing-package-roles-programmatically-ssis-service.md
      • managing-packages-and-folders-programmatically.md
      • managing-running-packages-programmatically.md
      • running-and-managing-packages-programmatically.md
      • understanding-the-differences-between-local-and-remote-execution.md
    • save-packages.md
    • security
      • access-control-for-sensitive-data-in-packages.md
      • identify-the-source-of-packages-with-digital-signatures.md
      • integration-services-roles-ssis-service.md
      • security-overview-integration-services.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
    • set-package-properties.md
    • ssis-designer.md
    • ssis-how-to-create-an-etl-package.md
    • ssis-package-upgrade-wizard-f1-help.md
    • ssis-quickstart-deploy-cmdline.md
    • ssis-quickstart-deploy-dotnet.md
    • ssis-quickstart-deploy-powershell.md
    • ssis-quickstart-deploy-ssms.md
    • ssis-quickstart-deploy-tsql-ssms.md
    • ssis-quickstart-deploy-tsql-vscode.md
    • ssis-quickstart-run-cmdline.md
    • ssis-quickstart-run-dotnet.md
    • ssis-quickstart-run-powershell.md
    • ssis-quickstart-run-ssms.md
    • ssis-quickstart-run-tsql-ssms.md
    • ssis-quickstart-run-tsql-vscode.md
    • ssis-toolbox.md
    • system-stored-procedures
      • catalog-add-data-tap-by-guid.md
      • catalog-add-data-tap.md
      • catalog-add-execution-worker-ssisdb-database.md
      • catalog-check-schema-version.md
      • catalog-cleanup-server-execution-keys.md
      • catalog-cleanup-server-log.md
      • catalog-clear-object-parameter-value-ssisdb-database.md
      • catalog-configure-catalog-ssisdb-database.md
      • catalog-create-customized-logging-level.md
      • catalog-create-environment-reference-ssisdb-database.md
      • catalog-create-environment-ssisdb-database.md
      • catalog-create-environment-variable-ssisdb-database.md
      • catalog-create-execution-dump.md
      • catalog-create-execution-ssisdb-database.md
      • catalog-create-folder-ssisdb-database.md
      • catalog-delete-customized-logging-level.md
      • catalog-delete-environment-reference-ssisdb-database.md
      • catalog-delete-environment-ssisdb-database.md
      • catalog-delete-environment-variable-ssisdb-database.md
      • catalog-delete-folder-ssisdb-database.md
      • catalog-delete-project-ssisdb-database.md
      • catalog-deny-permission-ssisdb-database.md
      • catalog-deploy-packages.md
      • catalog-deploy-project-ssisdb-database.md
      • catalog-disable-worker-agent-ssisdb-database.md
      • catalog-enable-worker-agent-ssisdb-database.md