I am seeking to run a simple import of data from a Progress database table to
SQL Server 7 using a DTS script. I need to filter the data by date to do so.

If I try to import from the source using a 'Where' condition that includes
the keyword "GetDate", I get an message saying 'Unexpected error occurred. An
error result was returned without an error message' when I parse the SQL.
This happens on the 'Source' tab of my DataDrivenQuery.

Should I be using the GetDate keyword for this - will it be translated into
whatever else is used to use the current date as a filter value? And if not,
what should I use instead? Any ideas.

The code I am parsing is 'SELECT* FROM SYTLEMAN.IRECOF WHERE IRDTTR=GETDATE()'

Thanks in advance for any tips.

Ian