Microsoft SQL Server Connector

Back Next

Processing Unicode characters

Before you enable pass-through partitioning in a

mapping

task when the SQL Query or Source Filter value of the configured partitions contain Unicode characters, you need to set certain system and custom properties for the Secure Agent in Administrator.

Select

Administrator

Runtime Environments

On the

Runtime Environments

page, select the Secure Agent that runs the

mapping

task.

Click

Edit

In the

System Configuration Details

section, perform the following steps:

Select

Data Integration Server

as the service and

DTM

as the type.

Edit the

OdbcDataDirectNonWapi

system property and set the value to

In the

Custom Configuration Details

section, perform the following steps:

Select

Data Integration Server

as the service and

DTM

as the type.

Enter

AddQuotesAlways

in the

Name

field and set the value to

Yes

The configured AddQuotesAlways property in the Custom Configuration Details section.

Click

Save

Pass-through partitioning

Download Guide

Watch

Comments

Cloud Connectivity Homepage

Communities

Knowledge Base

Success Portal

0 COMMENTS

We’d like to hear from you! Log in to comment.

Rename Saved Search

Table of Contents

Microsoft SQL Server Connector

Microsoft SQL Server Connector

Processing Unicode characters

Processing Unicode characters