SSIS - Truncation may occur due to inserting data
-
795]] Warning: Truncation may occur due to inserting data from data flow column "AS" with a length of 16 to database column "AS" with a length of 15. I resolved this issue yesterday but today it failed again. The package is successful if I run from Microsoft Visual studio. However, if I run initiate the job through SQL job agent it will fail. Does anyone have a better idea to resolve this?
-
795]] Warning: Truncation may occur due to inserting data from data flow column "AS" with a length of 16 to database column "AS" with a length of 15. I resolved this issue yesterday but today it failed again. The package is successful if I run from Microsoft Visual studio. However, if I run initiate the job through SQL job agent it will fail. Does anyone have a better idea to resolve this?
Please do not re-post - it will not get you a quicker or better answer, but may piss off some of the CPians around us :)
I'm not questioning your powers of observation; I'm merely remarking upon the paradox of asking a masked man who he is. (V)
-
Please do not re-post - it will not get you a quicker or better answer, but may piss off some of the CPians around us :)
I'm not questioning your powers of observation; I'm merely remarking upon the paradox of asking a masked man who he is. (V)
-
You're more than welcome..
I'm not questioning your powers of observation; I'm merely remarking upon the paradox of asking a masked man who he is. (V)
-
795]] Warning: Truncation may occur due to inserting data from data flow column "AS" with a length of 16 to database column "AS" with a length of 15. I resolved this issue yesterday but today it failed again. The package is successful if I run from Microsoft Visual studio. However, if I run initiate the job through SQL job agent it will fail. Does anyone have a better idea to resolve this?
-
795]] Warning: Truncation may occur due to inserting data from data flow column "AS" with a length of 16 to database column "AS" with a length of 15. I resolved this issue yesterday but today it failed again. The package is successful if I run from Microsoft Visual studio. However, if I run initiate the job through SQL job agent it will fail. Does anyone have a better idea to resolve this?
One of the issues I have run across over time is in the data itself. If your source is a legacy system then there may be a crlf issue, it can be either 1 or 2 characters. They sometimes use weird row terminators as well. I would check if AS is the last field in a row and then pull the data into a string and check the length of the field. VS may well treat line feeds differently than SSIS.
Never underestimate the power of human stupidity RAH
