How to specify the Integration service and database collations 1 Choose Servers—Properties—Advanced—Integration Service—General Data Source Information. In Default collation of ASQL strings, select the Integration service collation, as shown in Figure 13-1. In Default collation of target database strings, select the database collation, then choose OK. Figure 13-1 Specifying the Integration service and database collations 2 Restart the Integration service.