Data conversion issues
Hi there, I have ETL package on 2005 which give me below error.The column i am getting error it is numeric data type when i run on SSMS i don't see any bad data or any thing like that. [OLE DB Source [3335]] Error: There was an error with output column "SC_ID" (8269) on output "OLE DB Source Output" (3345). The column status returned was: "The value could not be converted because of a potential loss of data.". Can you help me out on this? Thanks, Dhaval
March 30th, 2011 2:28pm

Did you make any changes in the data type of the OLEDB Source output column manually?Nitesh Rai- Please mark the post as answered if it answers your question
Free Windows Admin Tool Kit Click here and download it now
March 30th, 2011 2:35pm

You could redirect the error rows to a flat file. This way you can see exactly which row is booming. For more information on how to do that, please look at: http://msdn.microsoft.com/en-us/library/ms140083.aspx
March 30th, 2011 2:41pm

Looks like data conversion happening and output data is large size then mapping column. You might need to convert this column into numeric with DT_NUMERIC here is syntax to data conversion http://msdn.microsoft.com/en-us/library/ms141704.aspx
Free Windows Admin Tool Kit Click here and download it now
March 30th, 2011 2:46pm

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

Other recent topics Other recent topics