SQL Server Metadata mismatch error

[amckinne]

I am pulling data from a SQL server database via ODBC to a flat file. One of the columns is a date column with a format of MM/DD/YYYY. It is defined by Datastage as a timestamp (Imported into Manager), but I receive the following message when I try to view data:

DSBrowser..AssetInfo.AssetInfoIn: DSD.BCIOpenR results of SQLColAttributes(AssetInfo.tDueDate) gave MetaData mismatch
COLUMN.TYPE Expected = Unknown Actual = Unknown

I can "see" the other data, but a 0 or nothing at all is in the date column.
I've tried changing the datatype to various things, but I cannot get the data in without the same error message.

Can anyone help me out? Any ideas would be appreciated!

Environment: Unix, Datastage 5.01

Thanks,
Angela

Environment: Unix, Datastage 5.01