November 14, 2008 at 12:32 pm
Does anyone have experience troubleshooting SSIS Error Code -1071607689? The entry in http://msdn.microsoft.com/en-us/library/ms345164.aspx describes it as DTS_E_OLEDBDESTINATIONADAPTERSTATIC_CANTCONVERTVALUE
- "The data value cannot be converted for reasons other than sign mismatch or data overflow".
November 17, 2008 at 1:49 pm
It would be easier to give you an answer if you gave some details like source, destintation, and if possible, some sample data.
You could also check out this article[/url] to learn how to log the data that is causing the error.
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
November 17, 2008 at 2:13 pm
It's Excel data that comes in formatted as text (even though all incoming data is numeric), and is converted from unicode to double-precision. What's odd is that some rows work fine, others error out. Examination shows that nothing is significantly different in the data.
The error reported from SSIS is too obscure to explain the problem.
Thanks for the link to your article (I read it yesterday searching for a solution to this). It's very useful.
November 17, 2008 at 2:25 pm
Yeah, the SSIS errors are basically useless which is why I wrote the article. I was getting the generic errors and needed to know what data was causing it. I need to get 2008 loaded up so I can see if the errors were improved.
So the error is occuring on conversion, not on insert? How many rows are we talking about? Can you use an IsNumeric function in a conditional split? I'm not sure what it is in SSIS/.NET off the top of my head.
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply