sql server reporting services: dtsx iterate rows of table -- sql server reporting services

dtsx iterate rows of table

John Grandy
3/13/2007 4:33:57 PM

sql server reporting services:

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.

Re: dtsx iterate rows of table

EMartinez
3/14/2007 7:29:29 PM

On Mar 13, 6:33 pm, "John Grandy" <johnagrandy-at-gmail-dot-com>
[quoted text, click to view]

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