COGNOiSe.com - The IBM Cognos Community

IBM Cognos 8 Platform => COGNOS 8 => Framework Manager => Topic started by: Aamir on 16 Aug 2006 09:24:07 AM

Title: How to use a Fixed length file as datasource in cognos 8
Post by: Aamir on 16 Aug 2006 09:24:07 AM
Hi
I know there is no concept of hotfiles in cognos 8. But how should I import a text file( or any file like excel,csv,...) and use it as a datasource in framework manager? Thanks in Advance.
Aamir
Title: Re: How to use a Fixed length file as datasource in cognos 8
Post by: MFGF on 29 Aug 2006 04:45:40 AM
You would probably need to get hold of an ODBC Text driver to read in data in this format.  Either that or use some other tool such as Data Manager or DTS to load the data into relational tables beforehand.

Regards,

MF.