SQL Server Metadata mismatch error
Posted: Thu Jun 13, 2002 3:28 pm
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
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