Hi,

I modified common template. I added a field 'default_financial_company'in UP_COM_CUSTOMERS table. According to documentation it is possible to change data model with Alter DataWarehouse Package, so I generate this package. So far I didn't generate an Exchange Schema.
I executed Alter DataWarehouse Package with ETLRunner.I got an DTS error (error0000.txt) however a table structure was properly modified and data import worked fine. I mean, a table UP_COM_CUSTOMERS was filled with previously exported BAAN data and field 'default_financial_company' was filled with zero value.

I generated an Exchange Schema and executed Upload package. I got a DTS error (error0001.txt). No records were processed.
Did anyone test Alter DataWarehouse Package? What happend with 'old' data when table definition change?

Regards,

Herdyx

everytime I have had to add a field I had to do it at the end of the table, because the alter table in SQL could not insert it in between existing fields.