HI, i am using oracle 10g database as my source and destination. i am trying to load data from stage to dimension using SSIS 2008. but i am not getting correct data to the target table. example Flex_value_id 50950 50960 50970 51981 50990 60960 50110 50120 50130 50140 56974 The source and target data types are same, if i am loading this to target means i am getting data like this. Flex_value_id 950 960 970 51981 990 960 110 120 130 140 56974 can anyone give solution for this issue senthil

Can you use dataviewer just before the destination table and see the values that are going into destination component?Nitesh Rai- Please mark the post as answered if it answers your question

thanks for your reply i have used and checked,while using datavieweri am getting correct data but the target does not have the saem senthil