I have an ETL and it fails because of some Unicode Characters. The unicode characters are getting inserted from somewhere in the application and we are still trying to ascertain the source of the same.But till then I need to run a T-SQL Query and find out
the rows( I know the column name ) that are causing this problem, modify the data to the correct format and then run the ETL.
Would i need to use a cursor? can anyone please advise?
It was a bit urgent thus any help would be great!
View Complete Post