Daily Archives: October 5, 2012

Finding and removing hidden characters in your data using dynamic T-SQL

It has been a long morning for me. It was supposed to be a standard run for our quarterly data aggregations but one of the data import SSIS packages kept failing. The problem was a conversion problem from varchar type to float and I kept getting the following error:

Msg 8114, Level 16, State 5, Line 1
Error converting data type varchar to float.

However, my data was numeric I checked it many times… or was it really 100% numeric?

Read the rest of this entry »


Tags: , ,

%d bloggers like this: