Data Conversion Transformation

Question

Post reply

Data Conversion Transformation

Steve Jones - SSC Editor

SSC Guru

Points: 736210
More actions
July 12, 2016 at 9:22 pm

#311697

Comments posted to this topic are about the item Data Conversion Transformation
July 13, 2016 at 1:28 am

This was removed by the editor as SPAM
July 13, 2016 at 3:31 am

This was removed by the editor as SPAM

Viewing 15 posts - 1 through 15 (of 18 total)

You must be logged in to reply to this topic. Login to reply

Andrew G SSChampion Points: 12809 More actions · Answer 1

Andrew G

SSChampion

Points: 12809

July 12, 2016 at 9:23 pm

#1889755

I dont know what hap

Koen Verbeeck SSC Guru Points: 259105 More actions · Answer 2

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

TomThomson SSC Guru Points: 104773 More actions · Answer 3

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

Joel Ewald SSCertifiable Points: 6120 More actions · Answer 4

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.

Ed Wagner SSC Guru Points: 287026 More actions · Answer 5

Not knowing much about SSIS beyond how to spell it, my guess based on knowledge of SQL. 😀

Tally Tables - Performance Personified
String Splitting with True Performance
Best practices on how to ask questions

SQL_Hunt SSC-Dedicated Points: 33518 More actions · Answer 6

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.

sestell1 SSChampion Points: 10230 More actions · Answer 7

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.

2BigSaints SSChasing Mays Points: 646 More actions · Answer 8

That is a bit of a surprise. Glad I haven't moved to 2016.

Carlo Romagnano SSC-Insane Points: 22669 More actions · Answer 9

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.

FridayNightGiant SSCertifiable Points: 7151 More actions · Answer 10

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.

gchornenkyy Say Hey Kid Points: 687 More actions · Answer 11

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

Konstantin Reu Hall of Fame Points: 3149 More actions · Answer 12

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