Hi There, I have a simple SSIS package that loads data from one sql server table to another. The first table has data over 4 characters long with a limit of 50 chars. The target is a table with a length of 4 characters. When the insert occurs data from the first table is automatically truncating rather than being routed by my redirect on truncation error. Is there some sort of toggle I clicked to truncate data as most posts are looking for the opposite and are trying to get rid of the error because of truncation.
SSIS 2015 and SQL Server 2014.
Thanks in advance.
asked Oct 26, 2016 at 03:21 PM in Default