Create Data Pump Attribute in DTS
Hello,
I have been tasked with a process that pushes multiple data from one central database to many other databases in DTS. I am using DTS to retrieve the data from the Oracle database, and push it to a SQL Server table. I'm using a dynamic properties task to modify the destination. However, the problem I'm running into is that the some of the tables being pushed have an extra field. So when I run the process, I need to move an extra field for certain tables. I'm pretty certain that I can figure out how to calculate for an extra field (haven't looked into it thoroughly, so please let me know if you have any thoughts on the subject). However, is there any way that you can add a data pump transformation, so I can add the extra column to map it from the source table to the destination table.
For example, in DTS, below is an example mapping that will explain my situation:
Source Table Dest. Table
------------ -----------
ID -> ID
Name -> Name
Email -> Email
However, some tables may have an extra field, say CreationDate, so is there any way I can create an extra transformation, to add:
Source Table Dest. Table
------------ -----------
ID -> ID
Name -> Name
Email -> Email
CreationDate -> CreationDate
Or, if adding a field isn't possible, is there a way I can remove a transformation?
Thanks,
Brian Mains
__________________
Brian
|