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