If anyone is interested, I found out how to make then asynchronous.

Replace

SET @osql_cmd = 'osql -E -d' + @DatabaseName + ' -S' + @ServerName + ' -Q"' + @sql_proc...

Hello,

There are a few possibilities, here would be the most obvious two:

1) Use a Conditional Split before your Insert to evaluate your NULLs and send them to Error_table

2) Use the...

I found the issue, I'm a bit ashamed of this beginner's mistake.

The connection string of the OLEDB Component of the Index Rebuild Task had been hardcoded to our Dev...

It is indeed obscure, never heard of this SQL Collection but it works!

I'll do some homework and research that collection.

Thanks a lot

I tried the reverse solution but it did not work out as it is also ordering letters on descending order.

I updated my original post with a more accurate query of...

It worked fine on the test sample, but when applying this to my real situation, it did not workout well.

Using DESC on the ORDER BY now evaluates the letters in...

Wow, can't believe it was that simple.

Guess I overlooked some basics and dug too deep.

Thanks