How Create record in SQL Server when Progress 9.1c record is created? 1

[DazS]

Every time a new job is entered into our Progress based ERP system, i want to take some of the entered data and use it to populate a SQL Server 2000 table.

Any ideas on the best way to do this ?

Database Trigger ?
Sample code, anyone ?

Thanks,

D.

 

[harebrain]

See thread292-636337.

We had a revelation that let's us skip DTS: the SQL Server scheduling agent is more appropriate (and easier.)

 

[DazS]

Lovely Jubbley.

Gives me something to go at.

Thanks very much.
D.