Chapter 2: Understanding Component Integration Services
When an ANSI query is received for a server that does not support ANSI syntax
The query will be converted to T-SQL if possible.