i cannot insert correct data to the target table
Hi, i am using oracle 10g database as source and target. i am trying to load data from stage to dimension, but i cannot get correct data to the target table. example Flex_Value_id 56955 56956 56957 56958 56959 56960 56961 56962 56963 56964 56965 56966 56967 56968 56969 56970 56971 while loading this to target i am not getting correct data example i am getting like this 56955 56956 56957 56958 56959 960 56961 56962 56963 56964 56965 56966 56967 56968 56969 970 56971 the source and target datatype is also same. can anyone give the solution for this senthil
November 24th, 2010 4:16am

Can you post relevant package graphics? Upload images first to www.skydrive.com, then copy & paste here. Thanks.Kalman Toth, SQL Server & Business Intelligence Training; SQL 2008 GRAND SLAM
Free Windows Admin Tool Kit Click here and download it now
November 24th, 2010 5:13am

thanks for your reply i have uploaded the image in the following link http://cid-d86d46fb969112ce.photos.live.com/self.aspx/Share/Image.bmp senthil
November 24th, 2010 6:23am

Unrelated to your issue: You don't need the Multi-cast if all you are doing with it is sending it to a Row Count. The Row Count allows rows to pass THROUGH untouched. Suggestion: Delete the Multi-Cast, and put the Row Count between the Script and the Destination. It probably won't improve performance a whole bunch, unless you have an extremely LARGE dataset in both number of rows and number of columns. This is because the Multi-Cast makes a copy of the data in-memory, and why use up memory if you don't have to? I know, it doesn't solve your problem, but it's a general best practice.Todd C - MSCTS SQL Server 2005 - Please mark posts as answered where appropriate.
Free Windows Admin Tool Kit Click here and download it now
November 24th, 2010 7:49am

Unrelated to your issue: You don't need the Multi-cast if all you are doing with it is sending it to a Row Count. The Row Count allows rows to pass THROUGH untouched. Suggestion: Delete the Multi-Cast, and put the Row Count between the Script and the Destination. It probably won't improve performance a whole bunch, unless you have an extremely LARGE dataset in both number of rows and number of columns. This is because the Multi-Cast makes a copy of the data in-memory, and why use up memory if you don't have to? I know, it doesn't solve your problem, but it's a general best practice.Todd C - MSCTS SQL Server 2005 - Please mark posts as answered where appropriate.
November 24th, 2010 7:49am

Hi, i am using oracle 10g database as source and target. i am trying to load data from stage to dimension, but i cannot get correct data to the target table. example Flex_Value_id 56955 56956 56957 56958 56959 56960 while loading this to target i am not getting correct data example i am getting like this 56955 56956 56957 56958 56959 960 the source and target datatype is also same. can anyone give the solution for this senthil HI senthil I can tell u why exactly that is happening but for now i can suggest that u either explictly cast again this column to the same datatype or add a derived column where in add another column as NEW_Flex_Value_ID As Flex_Value_id * 1 then load this New_Flex_Value_id to ur destination table and see if that works out its some bug i wanted to discuss .. but dont have the scenario with my machine now ... let me know if this work around works with you ... for me that the package was misbehaving around numeric "9" value in any value that was having 9 in it for eg 900 was becoming 90 ... but that was for all the values for a column i see in ur case its misbehaving for few values ... what is ur source by the way ... can u just play around for test : source as query like select Flex_Value_id .. only check and let us know the results .... Hope that helps ... Kunal
Free Windows Admin Tool Kit Click here and download it now
November 24th, 2010 8:22am

Hi, i am using oracle 10g database as source and target. i am trying to load data from stage to dimension, but i cannot get correct data to the target table. example Flex_Value_id 56955 56956 56957 56958 56959 56960 while loading this to target i am not getting correct data example i am getting like this 56955 56956 56957 56958 56959 960 the source and target datatype is also same. can anyone give the solution for this senthil HI senthil I can tell u why exactly that is happening but for now i can suggest that u either explictly cast again this column to the same datatype or add a derived column where in add another column as NEW_Flex_Value_ID As Flex_Value_id * 1 then load this New_Flex_Value_id to ur destination table and see if that works out its some bug i wanted to discuss .. but dont have the scenario with my machine now ... let me know if this work around works with you ... for me that the package was misbehaving around numeric "9" value in any value that was having 9 in it for eg 900 was becoming 90 ... but that was for all the values for a column i see in ur case its misbehaving for few values ... what is ur source by the way ... can u just play around for test : source as query like select Flex_Value_id .. only check and let us know the results .... Hope that helps ... Kunal
November 24th, 2010 8:22am

Thanks for your reply I am using the row count for logging information. i using the custom logging i need the row count for that. senthil
Free Windows Admin Tool Kit Click here and download it now
November 24th, 2010 10:18am

Thanks for your reply I am using the row count for logging information. i using the custom logging i need the row count for that. senthil
November 24th, 2010 10:18am

This is a duplicate post. The question is being answered here .SSIS Tasks Components Scripts Services | http://www.cozyroc.com/
Free Windows Admin Tool Kit Click here and download it now
November 24th, 2010 12:57pm

Thanks for your reply Kunal its working perfectly, i am getting the correct data to the target now. thanks senthil.
November 25th, 2010 12:17am

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

Other recent topics Other recent topics