Results 1 to 2 of 2
  1. #1
    Join Date
    May 2004

    Unanswered: How to re-query DTS transforms when schema changes.

    I'd like to know if it is possible to automatically (or through ActiveX programming) trigger a DTS transformation task to refresh it's query
    and auto re-map its source to destination columns based on the query.

    I have a DTS package that exports all columns from a table
    (Select * from table) with no special column transformations when
    copying to the text file destination. I'd like to be able to trigger
    a refresh of the column mapping. The "Define Columns" "Populate from Source"
    buttons on the Transform Data Task component does this but I'd like to achieve this action as a separate task.

    Thank you kindly,

    Sonya Lisi

  2. #2
    Join Date
    May 2003
    Parsippany NJ
    You can use "bcp out" instead of using task transform task + Text connection.

Posting Permissions

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