How to turn off SQL truncation error in Sagent

Product Feature: Installation / Upgrade

Operating System: NA

Database: SQL Server

Configuration: Sagent
 
Steps to turn of SQL truncate error:
  1. Take a backup of sagent registry export in PreProduction server or as per affected environment.
  2. Delete the registry key (“SetAnsiWarnings”) entry under [HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\Sagent\DataMart\RW\Customize\OLE DB\Microsoft OLE DB Provider for SQL Server] if exists.
"SetAnsiWarnings"=dword:00000001

       3. Restart the DFS service.
       4. Execute the plan. 
UPDATED:  December 1, 2017