Results 1 to 4 of 4

Thread: DTS 'Transform Data Task Property' GUI window

  1. #1
    Join Date
    Apr 2005

    Question DTS 'Transform Data Task Property' GUI window

    I am importing data from xls file to a db table with a dts. In the time of the dts creation I am using 'Transform Data Task Properties' GUI window to map incoming xls fields (source) to the table columns (destination).
    Question: Is there any way to invoke the 'Transform Data Task Property' GUI window in dts runtime and use it to change the mapping dynamically in the run time?
    Thanks, Vadim.

  2. #2
    Join Date
    Sep 2002
    Not as I aware of.

  3. #3
    Join Date
    Sep 2002
    You should be able to do this. I suggest that you have a look in the Wrox Press book called "Professional SQL Server 2000 DTS".

    However, just because you can do something doesn't mean you should. Dynamically adding datapumps needs a lot of thought and testing it could be an "interesting" task.

  4. #4
    Join Date
    Nov 2002
    New Jersey, USA
    I also recommend the wrox book on DTS. You can easily modify DTS package using VBScript.

    Other source for dts is http://www.sqldts.com/

Posting Permissions

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