I have two connection objects (source and destination), one
transformation task (task1) that imports data from source to destination
tables. And I have an ActiveX Script task.

The AxtiveX script task will loop through each table in a pre-defined
list, and programmingly remove all existing transformations in task1,
and add the following ActiveX transformation to task1:

Function Main()
DTSDestination(1) = DTSSource(1)
DTSDestination(2) = DTSSource(2)
Main = DTSTransformStat_OK
End Function

Everything seems to work except that only the first row in each source
table is imported. I want all rows in source table to be imported.

Any idea?

Hello q_test,

Your transforms will have nothing to do with how many rows you get. They
simply tell the pipeline what to do with the attributes. Very strange you
only import the first row. Providing you do not touch anything else about
the Data Pump task, have a look at it. Preview the Source data, look at
the last tab that tells the pump what row is first and what is last, when
the pipeline does run how many rows does it say it moved?.

Allan