Results 1 to 4 of 4

Thread: DTS 'Transform Data Task Property' GUI window

  1. 04-15-2005, 10:52 AM #1
    vadim
    vadim is offline Registered User
    Join Date
    Apr 2005
    Posts
    1

    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.
    Reply With Quote Reply With Quote
  2. 04-15-2005, 11:56 AM #2
    rmiao
    rmiao is offline Registered User
    Join Date
    Sep 2002
    Posts
    5,938
    Not as I aware of.
    Reply With Quote Reply With Quote
  3. 04-19-2005, 10:24 PM #3
    Stephen
    Stephen is offline Registered User
    Join Date
    Sep 2002
    Posts
    169
    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.
    Reply With Quote Reply With Quote
  4. 04-20-2005, 07:11 PM #4
    skhanal
    skhanal is offline Experts
    Join Date
    Nov 2002
    Location
    New Jersey, USA
    Posts
    3,932
    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/
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

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

Forum Rules