You didn't give near enough detail as to what you are doing and what you need. What is being repointed to the table, and which technology are you using?

Is the pointing done in a c# or vb6 app, or something internal to SQL server like a view to a linked server's table or a DTS package?

It sounds like you have jobs which execute DTS packages. You mention transforming in the job, but I'm wondering if you mean the job starts the DTS package, which then performs the transformation. Or does the job actually perform a transformation using TSQL code?

Which technology is used for the new odbc datasource which is the new home for the table? Another SQL Server of a different version? MySQL? Access?

So many questions that need answering first, then we can help you come up with a plan to solve this.