On 5/25/2004 at 6:10 PM Dan Wilson wrote:

> I am attempting to use external tables for the first time. My goal is
> to import data using an external table and an SP. I have tested the SP
> and the code that creates the external table, and it works for the first
> record written to the external table. However, the second record fails
> inside the SP with Error -413, Overflow occurred during datatype
> conversion, Code 335544334 Conversion error from string '0'.
>

OK, I am officially an idiot.

I fixed it, it was stupid, it was exactly what the error said it was, and it was something I unintentionally uncommented back into existence, didnt notice I had done so, and never looked at that part because I knew it was turned off....

time to go sit in the corner and sing the "I'm a little moron" song (sung to the tune of "I'm a little teacup")....

Thanks for all the help (blushing mightily at my stupidity),

Dan.