Advertisements

Archive

Posts Tagged ‘hidden characters’

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

October 5, 2012 1 comment

Today I was struggling with one issue which keeps my SSIS package failing in one of the data imports.And came across one of the blog. 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?

Apparently there are some crazy hidden characters that you cannot see when you just glimpse at data. One of the best ways to find out if your data has some non-numeric characters in it is by running a simple query.

Read more...

Advertisements
%d bloggers like this: