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 ActiveX script task will loop through each table in a pre-defined list, and programatically 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 Suggestions

Thanks in advance