R
Rob Debbage
Guest
ScrPDB is not Pro2SrcPDB so that would explain the error: ** Unknown Field or Variable name - Pro2SrcPDB. (201) To expand on Satya's feedback, you should have the following Pro2 fields in the SQL Server table, in addition to some/all fields from the corresponding OpenEdge source table: prrowid (Primary Key) Pro2SrcPDB pro2created pro2modified As an example the following table definition was taken from the SQL script generated in Pro2SQL 4.6.7 for the Sports2000.Benefits table; the definitions are the same in Pro2SQL 5.0.2: CREATE TABLE [DBO].[benefits] ( [prrowid] varchar(36) not null PRIMARY KEY NONCLUSTERED, [empnum] integer null, [healthcare] varchar(16) null, [lifeinsurance] integer null, [pension401k] integer null, [stockpurchase] integer null, [medicalspending] integer null, [dependentcare] integer null, [Pro2SrcPDB] varchar(12) null, [pro2created] datetime null, [pro2modified] datetime null, ) Kind regards, Rob
Continue reading...
Continue reading...