DSXchange

Ray, I got an error when Browsing Source of CSV file in PS : String[1128]-2006-09-02 01:24:16 3704 - Operation is not allowed when the object is closed. String[1107]Menu item 41 String[1165]ADODB.Recordset I did: 1. define MCIROSOFT ODBC txt,csv driver System DSN to access directory containing all C...

Then how does ProfileStage store the connection information in the repository, and where does ProfileStage store the Specification/Analysis Report Database information? Although the Tables Information looks like *.TXT, I think PS needs to place them in somewhere, isn't it? However, It's just my gues...

Ray, it's good to know PSDB in DB2 is working fine with PS since we are going to use DB2 as the source. It's hard to believe PS is choked with Oracle since they all went through ODBC driver to connect to DB. Correct me if I am wrong, I thought PS utilize MDB(Access) to store PS internal DATA such as...

Ray, thanks for the help! It boosts the confidence to work with this product.

Hi All, Just to confirm with whoever is experienced in accessing flat file using PS! Has anyone successfully configured the Data Direct ODBC driver to access CSV file from PS? I know there is no problem to access the XLS like a table using ODBC, how about the flat file(CSV, fix-length,..)? Thanks fo...

Ray, Thanks! I know what you mean now, and it works! Thanks again.

Craig, Thanks for reminder! I did try the Omit option and it worked for me. I just don't understand why this installation ddoesn't work for me while the other works perfectly using AdminID login... Ray, Thanks for the information! Could you please elaborate on "how to activate NetworkCard for T...

Hi All, Has anyone encountered similar problem as following: Login Windows XP PRO SP2 as local Admin, Install DS 7.5.2x(Windows version) server and client in the same machine with valid license key. Then restart the PC, login XP as same Admin ID. I got the error: Failed to connect to host: localhost...

That's great they put the fix in 7.5.1.A. I just heard IBM has come out with 7.5.2(Not official, but is 7.5.1.A above), this is recommended if you want this fix since this version contains a lot more fixes. Ask for your IBM representatives. As per my experience, to apply the patches doesn't take too...

Just add one more point to Ray's comment... If you export the Job Executables to another NEW SERVER that is the same platform with the OLD SERVER, the job should run as usual without having to recompile the job in NEW SERVER. Which means there is no need to install the C++ compiler in NEW SERVER tha...

This is a knon bug that has been fixed in latest patch for 7.5.1.A. Contact IBM for the patch download..

Try to export the executable only from development to Production, and run it in produciton to see if there is an error. Let me know what happen..

Hi Guys, I don't agree with the statement of Bad Performance in Transformer Stage PX. I have posted similar statement to defense PX Transformer couple months ago, but probably no one paid too much attention to it at that time. Actually, Ascential Senior Engineer has confirmed with me that the statem...

Kumar,
We have to schedule the 6 instances to wait for the files arrival in a certain period, and we don't know when exatly the file will arrive. That's why we have to run them in parallel.
Thanks for your advise.

No, The warning message goes away if the jobs are run sequentially.