i cannot insert correct data to the target table
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
November 24th, 2010 4:17am

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
Free Windows Admin Tool Kit Click here and download it now
November 24th, 2010 4:37am

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
November 24th, 2010 5:54am

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics