DSXchange

Posted: **Mon Aug 23, 2010 3:38 am**

Hi ,

Could you please help me in removing below warning from my job....
I am not able to understand ..why this warning is coming?

Code: Select all

Lkp_Validation,0: When binding input interface field "T_PROD_INFO" to field "T_PROD_INFO": Implicit conversion from source type "string[max=20]" to result type "string[max=4]": Possible truncation of variable length string

Posted: **Mon Aug 23, 2010 4:23 am**

No problem in doing so, but you need to answer the following question first:

If your data contains "Hello There", what should the resultant string value be?

Posted: **Mon Aug 23, 2010 4:41 am**

"Hello There"

Posted: **Mon Aug 23, 2010 4:47 am**

That is not going to happen if you move it to 4 chars string.

So you will need to expand the target to 20 chars length.

Posted: **Mon Aug 23, 2010 4:52 am**

Hi

My target source everything is 20 bytes...That is why I am wondering why this is happeing?

Posted: **Mon Aug 23, 2010 5:05 am**

Your target column is VarChar(4).

Check again.

Posted: **Mon Aug 23, 2010 5:29 am**

If I understand it correctly, one of the links in Lkp_Validation lookup stage has it as varchar(4), check that.

Posted: **Wed Aug 24, 2011 9:52 am**

I just fixed a similar warning and this solution worked for me.

I changed the column defintion as Varchar() and set Unicode in the extended property, in the job that threw the warning.

Check if this works for you.

DSXchange

Implicit conversion from source type string[max=20]

Implicit conversion from source type string[max=20]