Talking with IBM/Ascential Australia and they indicate the problem may be due to our use of SQL Server 2005. ProfileStage has only been certified with 2k.
We were a little naive when starting our profiling exercise and didn't realise we would need a database server to host the PSDB. The (incorrect) assumption was that ProfileStage would provide its own. Read the installation manual!
In a mad rush, we downloaded a 180-day evaluation copy of SQL Server 2005 off the Internet and, once XP Pro was upgraded to SP2, the only issue was our missing IIS. There was so much trouble getting admin rights for our PCs and the PS software that we couldn't be bothered running the gauntlet again for a Windows install disk. The SQL Server 2005 installation did mention we may lose some functionality...
Our issue with the (missing) BROWSE function is viewing the data we are profiling. The data in the PSDB cannot be viewed through SQL Server because it is encrypted as hexadecimal. We cannot see it through PS. And our data sources are not TRUE fixed width files.
The far right columns are sometimes incomplete and there are no trailing spaces. This would be fine if the final column was ragged right, but the record may end a few columns previously. Hence, my import to SQL Server "wraps" the records and misaligns them.
Zac.
