I am converting a number of SQL Server 2000 databases, with numerous tables, to SQL Server 2008 R2 Express. I just learned that one of the limitations with the express version is that one can't save the DTS translation tables and routines with the Express version. Given the number of databases, tables, table and field name changes and the need to update data between the two SQL Server formats during our development process, I need some type of DTS where the translation tables and routines can be saved.
Can anyone recommend a 3rd party DTS program?
Thanks for the help!