I have a problem when using SQL Server 2005 BIDS (Business Intelligence Development Studio) when connected to an Oracle data source. The Query Designer generates the old Oracle SQL syntax instead of ANSI SQL. This is with the Oracle 10g
So, I would really appreciate it if anybody knows how to get the Query Designer to generate the ANSI SQL.
View Complete Post