dtsx iterate rows of table

In a dtsx , is it possible to use a For Loop or ForEach loop to iterate
through the rows of a table , extract the values of certain columns , and
conditionally call a sproc ( that takes as parameters the values of some of
the columns ) ?
How to do this ? Or is a dtsx loop not the recommended way to perform this
task.On Mar 13, 6:33 pm, "John Grandy" <johnagrandy-at-gmail-dot-com>
wrote:
> In a dtsx , is it possible to use a For Loop or ForEach loop to iterate
> through the rows of a table , extract the values of certain columns , and
> conditionally call a sproc ( that takes as parameters the values of some of
> the columns ) ?
> How to do this ? Or is a dtsx loop not the recommended way to perform this
> task.
You may want to repost on the DTS/SSIS message groups. They are:
microsoft.public.sqlserver.dts and
microsoft.public.sqlserver.integrationsvcs. Sorry I could not be of
greater assistance.
Regards,
Enrique Martinez
Sr. SQL Server Developer