rhythmk (6/16/2014)
I am getting below warning message while executing the package and eding up loading half of the data nd failing the package.
Truncation may occur due to retrieving data from database columns
So what is the error ?
Can you please post the error message as it may be a warning message but not always error ?
Nicely spotted.
It's a warning, not an error.
The only way you can get rid of this warning message is when the length of the column in the data flow is smaller or equal than the column width of the destination column.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP