problem while craeting connection between source and server

shaonli · Post by **shaonli** » Tue Dec 11, 2007 3:42 am

Hi,

I am very new to profile stage.I want to make connection between the analysis server and the source database of profile stage.In my case some flat files have been put in the server path.I am not able to make connection to that source or import metadata.
I have only established connection between repository and server.

Please help.

Thanks
Shaonli

lstsaur · Post by **lstsaur** » Tue Dec 11, 2007 11:44 am

First, you need to populate a DSN, e.g. ODBC4Text, in your odbc file. After that then go to PS-->Import-->Load Database Meta Data-->Select Server-->Specify Source Connection-->New Database Name.