July 12, 2016 at 9:22 pm
Comments posted to this topic are about the item Data Conversion Transformation
July 12, 2016 at 9:23 pm
I dont know what hap
July 13, 2016 at 1:21 am
One hooray for the inconsistency of SSIS! 🙂
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
July 13, 2016 at 1:28 am
This was removed by the editor as SPAM
July 13, 2016 at 2:45 am
If SSIS were a civilised piece or work it would give me the option to tell it allow or disallow truncation, and if I picked disallow tell it what to do with long values.
Tom
July 13, 2016 at 3:31 am
This was removed by the editor as SPAM
July 13, 2016 at 5:05 am
Got me on this one.
I need to play with SSIS in 2016.
I just guessed that the truncation would work similar to previous versions and throw an error unless you specified to handle it differently and route it somewhere else.
July 13, 2016 at 5:36 am
Not knowing much about SSIS beyond how to spell it, my guess based on knowledge of SQL. 😀
July 13, 2016 at 6:01 am
Had a doubt between option # 2 and 4...but I finally decided to go by option # 4 (Rows with 20 or less characters are passed through to the output. Those > 20 are routed to the error output.) and did not score anything.
Why not option 2 is the right one? If anyone had tried with this option, please let me know more on this.
Thanks.
July 13, 2016 at 8:21 am
One of the many reasons I never use this transform.
I do all my data conversion in a Derived Column task, which does let you handle truncation errors by column.
July 13, 2016 at 8:29 am
That is a bit of a surprise. Glad I haven't moved to 2016.
July 13, 2016 at 8:45 am
I found this:
https://msdn.microsoft.com/en-us/library/ms141679.aspx
From BOL:
Truncations. A truncation is less serious than an error. A truncation generates results that might be usable or even desirable. You can elect to treat truncations as errors or as acceptable conditions. For example, if you are inserting a 15-character string into a column that is only one character wide, you can elect to truncate the string.
July 13, 2016 at 8:54 am
I'd be very very surprised if this changed for 2016. Will have to test when I get home. Currently working on 2014 and the default for truncation is Fail Component, you have the option to redirect the row or ignore the failure.
July 13, 2016 at 9:10 am
The default setting for truncation is failure / error.
from MSDN:
Fail Component The Data Flow task fails when an error or a truncation occurs. Failure is the default option for an error and a truncation
the "correct" answer is actually not the correct one
July 18, 2016 at 12:33 pm
Just checked
1. MSDN
https://msdn.microsoft.com/en-us/library/ms141706.aspx no mentioning about truncation.
2. VS Studio 2015 & 2016 project. Behavior as expected - by default component configured to fail. Test proved that.
Where is quality control in QoT ?
MS SQL 2008 MCITP x 3
MS SQL 2012 MCSE x 2
Viewing 15 posts - 1 through 15 (of 18 total)
You must be logged in to reply to this topic. Login to reply