I am trying this from 5 hrs and unable to get a solution.

In target table i have that column as numeric.

I tried getdate() with datatype databasedate but it is returning 2009-12-21. So that value is not going into target table sand saying it as invalid number.

I want it ti look like 20091221, only then it goes into targat table