Accessing Teradata DB via SQL Server

Database

Accessing Teradata DB via SQL Server

I have to write an extract in SQL Server accessing a teradata database.  I'm running into problems with fields that have been defined with a column title. 

If I select * from table - the select fales because it's trying to select 'column title' from table rather than select column_name from table.

So I changed my query to select column_name from table & receive an error message Invalid column name 'column_name'.

Both sql statement work in Teradata SQL Assistant - just not in SQL server.

Any ideas what the problem could be?  This is the 2nd time I have worked with teradata.