The new GUIDBRACES parameter has been added to the MSQL CAPI_CONNECTION statement in the dbmover.cfg configuration file.
GUIDBRACES={
Y
|N}
Optional. Controls whether PowerExchange retains or removes braces { } around GUID values in data captured from registered SQL Server columns that have the uniqueidentifier datatype. If the PowerCenter session will write the data to SQL Server target uniqueidentifier columns, set this parameter to N to remove the braces. Otherwise, the session will encounter writer errors.
N
. Remove braces.
Y
. Retain braces.
Default is Y.
For more information, see the "DBMOVER Configuration File" chapter in the