Load Data from flat file into PSDB

mandyli · Post by **mandyli** » Wed Feb 02, 2005 7:47 am

HI

I am new to profile stage. already we are created Sorce database connection. I want to load some flat file into PSDB .

please help me.

Thanks
Man

vmcburney · Post by **vmcburney** » Wed Feb 02, 2005 4:04 pm

ProfileStage investigates the data through ODBC drivers. You need to set up an ODBC flat file driver that points to the flat files you are trying to profile. You can then commence the process.

mandyli · Post by **mandyli** » Thu Feb 03, 2005 12:40 am

Thanks ya ..

mandyli · Post by **mandyli** » Thu Feb 03, 2005 6:33 am

Hi vmcburney ,

as per Profile stage Install guide i created DSN for SouthBreeze. I have one doubt some one said . i need to create client and server both side DSN with same name.

I create DSN and given database path name following path in the client PC.

E:\Ascential\ProfileStage\Client\Samples\SouthBreeze .

still i can't able to access SouthBreeze DSN.

please help.

Thanks
Man

mdan · Post by **mdan** » Sat Feb 05, 2005 4:12 am

Hi mandyli,
1) use Ascential drivers. You may install them from (almost) any Ascential CD.
2) you may want to check if your DSN is working from any ODBC enabled software, even from MS Access (create a linked table, you'll get a series of warnings from ascential driver regarding license that you may ignore it)
3) Check if you have QETXT.INI file in E:\Ascential\ProfileStage\Client\Samples\SouthBreeze folder. If not, check if your DSN is listed in ODBC manager.
4) use system DSN

BR,
Dan

mandyli wrote:Hi vmcburney ,

as per Profile stage Install guide i created DSN for SouthBreeze. I have one doubt some one said . i need to create client and server both side DSN with same name.

I create DSN and given database path name following path in the client PC.

E:\Ascential\ProfileStage\Client\Samples\SouthBreeze .

still i can't able to access SouthBreeze DSN.

please help.

Thanks
Man