Unable to import sequential file metadata into IA
Posted: Tue May 19, 2009 6:27 am
I am at a customer site... using IA 8.1... trying to run analysis against sequential text files (.txt)... Windows XP environment... I create the ODBC for the source... I create the data store, data source in IA... I go to 'Import Metadata' and 'Identify Next Level' where it DOES show me the Data Source name and that there is a schema below it... however, when I hilite the schema name and click 'Identify Next Level' it says it is 'Finished' but none of the columns appear and 'Import' continues to be grayed out... I've changed and re-changed to ODBC many times trying to get it to work... I've tried many different delimeters, column headers and not, .TXT and .CSV, etc.... and I always end up at the same spot... am I missing something???... is there a little-known trick to make this work???... accessing DB tables works just fine... as an FYI, I do NOT have access to DataStage or any other IS product to try to bring the metadata in differently... if anyone can help or make suggestions, it would be appreciated...