How can we pass transform data task source and destination dyanmically . Or
can we call a transform data task from activex script dynamically in dts

Hello Vikram,

You can use a Dynamic Properties task or you can set things up in cide through
an Active Script task.

http://www.sqldts.com/default.aspx?213


Allan Mitchell
www.SQLDTS.com
www.SQLIS.com
www.Konesans.com

but this article states that "the old source table must be the same
structure as the new one, and the same applies for the destination table."
But i want source and destination can be anything with different structure.
IN my case source is a stored procedure with some parameters, and parameter
count will differ in each case ...

"Allan Mitchell" <allan (AT) no-spam (DOT) sqldts.com> wrote

Hello Vikram,

If the metadata of the transforms change i.e. columns change from one run
to the next then you will need to rebuild the Transform data task transformations
every time or design a seperate transform data task for each eventuality.
DTS will not auto remap.

Allan Mitchell
www.SQLDTS.com
www.SQLIS.com
www.Konesans.com