Is it possible to get a transform task to process one record at a time and
have subsequent workflows execute per record? I have looping implemented in
my package via an ActiveX Script. I'm using DTS in SQL Server Enterprise
Manager 2000. I'm not an experienced DTS user. Other examples I have seen
that involve looping all seem to use Execute SQL Task? I am doing a lot of
column mappings from one SQL DB to another, so the Transform task seems much
simpler becuase all of the column mappings are taken care of. I am trying
tot process record by record so I can log errors and upate record statuses in
the source with success or failure.
--
Leah