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.