question

polo avatar image
polo asked

ssis is automatically truncating strings

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. Paul
sql server 2014ssis2012truncate
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

0 Answers

·

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.