Does anyone know if there is a way to dynamically define DTS Transformations/Data Pumps? The situation is: I want to give my users the ability to bulk upload data to a there table with columns/fields of there choice.
The problem is without creating a DTS for each user this can't happen. If i could create a dynamic DTS where i could define what data to pump into what fields this would solve the issue.
I know how to change the table structure for there custom fields but I don't know how to change the DTS dynamicly.