Teradata - DTS Parameter Passing

Third Party Software
Not applicable

Teradata - DTS Parameter Passing


I am new to Teradata.

I am trying to pull Teradata data into SQL Server 2000 using a DTS. I need to pull a month data based on the month parameter passed. DTS throws an error when I try to use '?' in the query. What is the right way to use a parameterised query in DTS?

Ex: I need to pass inv_month as parameter from DTS Global Variable.

select * from invoices where inv_year=2007 and inv_month = 5

Thanks in Advance,