change transformations dynamically - SQL Server 2000 DTS

[ReportDr00]

how could i change the transformations for my transform data task dynamically?

I have active x task, source connection, destination connection and connected by transform data task and have global variables to set source sql statment and destination sql statement and i have dynamic properties task between active x task and source connection.


Active X task ----> Dynamic Prop Task ---> Source Conn ------> Destination Conn

I can change source and destination sql statments using global variables in dynamic prop task, but how can i change the transformations between source and destination columns?
Is it possible ? Any ideas will be greatly appreciated

Regards
Armani

 

[AlexCuse]

I don't think you can do this, and frankly I don't see why you would want to be able to? It seems it would be much harder to maintain a program to set up your mappings than it would be to just maintain separate data flow tasks with the desired mappings.

If you are looking to do this for looping purposes (loading different files) you might look in to using BULK INSERT where you can specify different format files (of course, this depends on what your source is).

Hope this helps,

Alex

[small]----signature below----[/small]
You can't fit a square data in a round table