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.


more ▼

asked Oct 26, 2016 at 03:21 PM in Default

avatar image


(comments are locked)
10|1200 characters needed characters left

0 answers: sort voted first
Be the first one to answer this question
toggle preview:

Up to 2 attachments (including images) can be used with a maximum of 524.3 kB each and 1.0 MB total.

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here



Answers and Comments

SQL Server Central

Need long-form SQL discussion? SQLserverCentral.com is the place.



asked: Oct 26, 2016 at 03:21 PM

Seen: 88 times

Last Updated: Oct 26, 2016 at 03:21 PM

Copyright 2018 Redgate Software. Privacy Policy