Hi,I would have thought the DDT would have converted the data type provided SQL permitted it. However, I wonder would this work as it would allow you to add a new field to the existing table without having to create a new table:-
1. Rename the existing field and give it a temporary name.
2. Build a new package and update your database.
3. Delete the rename history in the DDT.
4. Add a new field to the existing table with the correct data type and the original name.
5. Build a new package and update your database - this will give you a new field with the correct name and datatype and the old field with the wrong data type and a different name.
6. Copy the data from the temporary field into the new field.
7. Delete the temporary field in the DDT.
8. Build a new package and update your database - this will remove the field with the wrong data type.
9. Delete the delete field history in the DDT.
This would mean you don't need a new table.
Aaron