Thanks for replying me. Sorry for the lack of details.
Its a dts job, retrieving data from source systems , transforming it and mapped into tables in the sql server. Now, all remains, except the final mapping to the tables that resides in sql server shall be changed to greenplum server.
If i were to do it manually, changing the final target odbc connection, remapping each fields, it would be very tedious.
Do you have any brilliant idea to perform this task in an automated way?