Results 1 to 1 of 1
  1. #1
    Join Date
    Oct 2003
    Posts
    1

    Question Unanswered: DTS Dynamic Datapump - updated!

    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.

    This link is half way there but i need the dynamic fields side? http://www.sqldts.com/default.aspx?213

    Please help! – if you don’t quite understand please let me know so I can try and make this clearer – thanks.
    Last edited by quiksilv; 10-06-03 at 08:41.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •