August 28, 2012 at 10:50 am
hi
in my package i am gettign error like ,
truncation may occur due to inserting data from data flow column "Copy of Column 34" with a length of 20 to database column product" with a length of 5.
please help me.
I am new to ssis
August 28, 2012 at 10:59 am
harri.reddy (8/28/2012)
hiin my package i am gettign error like ,
truncation may occur due to inserting data from data flow column "Copy of Column 34" with a length of 20 to database column product" with a length of 5.
please help me.
I am new to ssis
It's probably a warning rather than an error.
If you think of an SSIS dataflow as the movement of data through a pipeline, from one variable to another, you might start to get the picture.
The problem you have is that your source variable has been defined as 20 chars long and you are moving its data to a variable which is 5 chars long - hence the risk of data loss which SSIS is warning you about.
You need to fix the datatype of the source data to remove the warning. Sorry but no time to explain the detail of this now.
The absence of evidence is not evidence of absence.
Martin Rees
You can lead a horse to water, but a pencil must be lead.
Stan Laurel
August 28, 2012 at 7:00 pm
Its actually not a warning....its is an actual error caused the setting 'Fail Package'(or FailTask) on the 'Truncation'. You can set it to 'Ignore Failure' on Truncation and it will work fine.
Really but you should make the make the size of the source and the destination col the same.
September 21, 2012 at 2:31 pm
Change the destination db field if you can, or "T"ransform the source to limit the length to 5.
I have seen this "error" many, many times and for me it has never been a show stopper, but more of a "hey, look out, this may happen" type of thing. 😉
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply