datatype conversion

[laxmi_etl]

Hi,

My problem is like this...

One of my source fields(A) has a datatype varchar(22).
But my target table has that field as Integer(10) when I try to
convert it as interger by using the fallowing function
AsInteger(lnkdummy.A) in Transformer
it is giving Zero's instead of values 1956,1975 etc.
Is there any suggesions on this

Thanks

[ganesh123]

Its helpful that when you mark the topic resolved you should also provide the solution like how you did ?

Its helpful for other users.

[us1aslam1us]

The OP has specified the solution in the other post.
This seems to be a duplicate post. And it would have been nice if the OP had deleted this post by themselve instead of marking it resolved..