View native query Grayed out

Here are a couple of things you can try.

For a SQL Query load:

1. Connect using ODBC but do not add the SQL Query.
2. Right click on the database and select Transform Data.
3. Open Advanced Editor and add a comma after your last step.
4. Call the next step something like SQL or LoadSQL. Make your code look like this

SQL = Value.NativeQuery(Previous Step Name, "SQL Query Here",null)​

1. Now check to see if you can view the Native Query. If not then try adding an additional parameter:

SQL = Value.NativeQuery(Previous Step Name, "SQL Query Here",null, [EnableFolding=true])​​

For data loads without the SQL Query

1. On the Source step add HideNativeQuery=false like this

= Odbc.DataSource("data source", [HierarchicalNavigation=true, HideNativeQuery=false])

Then check to see if you can see the Native Query.

I'm running ODBC and I'm not having issues seeing it.