ForEach Loop and Data Flow

In my Control Flow, I execute a data flow that opens a flat file and populates the file into a recordset.

Back to my Control Flow, I have a ForEach container that uses a ForEach ADO Enumerator. Inside the ForEach, I execute an "Execute SQL Task" that updates a table.

This is where I'm confused, while in the ForEach, I also want to call a Data Flow and use the current record (record in my ForEach) and perform several lookup tasks. Unfortunately, I'm now sure how to use the ForEach record as a source in my Data Flow....What am I missing?

Thanks,
Gary

We need to get the column values for each record in the "ForEach ADO Enumerator" in some variable.
Then for the tasks inside the ForEach container - we can use those variables.

Similar example is @. http://www.codeproject.com/useritems/foreachadossis.asp

Thanks,
Loonysan

sql

For each loop

Hi,

I have a dataset created in a data flow task. I want use a for each loop in the control flow area of the package to process every row individually in the dataset. How can I do this?

I am currently using a "Recordset Destination" because it says that it creates and populates in memory ADO dataset and I read somewhere that this could be used anywhere in the package. I have even assigned a variable DS which has an object datatype to the Recordset Destination task. How do I use this now in the for each loop container in the Control Flow task? I also need to know if I can use the DataReader Destination task instead as it uses ADO.NET vs just ADO for performance reasons?

Please help me with the above problem as I am working on a demo.

Thank you!!

Here's how you do it: http://blogs.conchango.com/jamiethomson/archive/2005/07/04/1748.aspx and there is a downloadable demo on there as well

The only difference is that in the example given here the recordset object variable is populated with an Execute SQL Task rather than the Recordset destination but thereafter the same applies.

You cannot use the DataReader destination by the way!

-Jamie

For a user of RS2000 but a non-programmer

Can someone tell me how to utilize the new calendar control in 2005. do i
have it right that it is supposed to give me a pop-up to choose a date from?
I have looked all over the msdn and the newsgroup here and havent found
anything real definitive. it could very well be that i dont know what im
looking for. i found learning the reporting service to be fairly intuitive
and well documented enough to do basic reporting with little programming.
so im wondering since i cant find out how to do this if it is because it
requires a code-behind. if it does could you point me to the docs on how.
i may be able to trudge through it with my limited programming knowledge.
TIA for any help.
MattWhat is most likely happening is that your parameter is defined as text, not
as a date/time. If date/time it automatically shows up. In layout mode,
Report menu, Report Parameters. Click on the parameter and change to
date/time.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Matt" <Matt@.matt.com> wrote in message
news:ugk9pK37FHA.3804@.TK2MSFTNGP12.phx.gbl...
> Can someone tell me how to utilize the new calendar control in 2005. do i
> have it right that it is supposed to give me a pop-up to choose a date
> from?
> I have looked all over the msdn and the newsgroup here and havent found
> anything real definitive. it could very well be that i dont know what im
> looking for. i found learning the reporting service to be fairly
> intuitive
> and well documented enough to do basic reporting with little programming.
> so im wondering since i cant find out how to do this if it is because it
> requires a code-behind. if it does could you point me to the docs on how.
> i may be able to trudge through it with my limited programming knowledge.
> TIA for any help.
> Matt
>|||that was way to easy....one last question...you dont get to get away that
easy...is there a time option...i want to add a default time...would i
have to add the time string to the end of the parm field once i get it
"Bruce L-C [MVP]" <bruce_lcNOSPAM@.hotmail.com> wrote in message
news:%23iQfT%2337FHA.1864@.TK2MSFTNGP12.phx.gbl...
> What is most likely happening is that your parameter is defined as text,
not
> as a date/time. If date/time it automatically shows up. In layout mode,
> Report menu, Report Parameters. Click on the parameter and change to
> date/time.
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "Matt" <Matt@.matt.com> wrote in message
> news:ugk9pK37FHA.3804@.TK2MSFTNGP12.phx.gbl...
> > Can someone tell me how to utilize the new calendar control in 2005. do
i
> > have it right that it is supposed to give me a pop-up to choose a date
> > from?
> >
> > I have looked all over the msdn and the newsgroup here and havent found
> > anything real definitive. it could very well be that i dont know what
im
> > looking for. i found learning the reporting service to be fairly
> > intuitive
> > and well documented enough to do basic reporting with little
programming.
> > so im wondering since i cant find out how to do this if it is because it
> > requires a code-behind. if it does could you point me to the docs on
how.
> > i may be able to trudge through it with my limited programming
knowledge.
> >
> > TIA for any help.
> >
> > Matt
> >
> >
>