Yet another late reply:

We mostly use xp_cmdshell + BCP in combination with format files. I'd be very interested in seeing a CLR assembly that would be able to read a...

noeld (3/4/2009)

BCP should OUTPERFORM this by far.

The problem is that it is NOT...

That's a good idea, but it would still not recognize cases such as

'20020229'

'0'

'00000000'

Thank you anyway 🙂

Thank you very much for the hints, that works nicely, so far!

However, is there also a solution for other conversions than date-conversions? (e.g. overflow when converting to smallint, conversion error...

e.g. the following simple examples:

SELECT CONVERT(datetime, '20031234') -- This causes an overflow

SELECT CONVERT(datetime, '2003123') -- This causes a conversion error

In more practical terms, I was trying to import a...

I've already found kind of a solution for the out-of-range error, that will produce NULL instead of an error (you just have to go through all NULLS instead of the...

Sorry, problem solved or at least I could figure out it had nothing to do with using or not using the CTE.

regards

- spit