Startloop and Endloop activity.

laknar · Post by **laknar** » Thu Mar 12, 2009 11:10 pm

i have a job to write the below values to a file(delimited)

Number,Filename
1,File1.txt
2,File2.txt
3,File3.txt

How can i extract and pass the values into Startloop and Endloop activity.
do i need nested loop for this?
Please suggest me.

ray.wurlod · Post by **ray.wurlod** » Thu Mar 12, 2009 11:50 pm

I don't really know what you want to achieve. Is it a list of the numbers, or a list of the file names, or a list of the pairs, that you wish to pass to the Start Loop activity?

The easiest way is to use an upstream Execute Command activity to read the file (perhaps with filtering), then a user variable to map the line terminators (which by now are probably field marks) to a delimiter character that you will be specifying in the Start Loop activity.

laknar · Post by **laknar** » Fri Mar 13, 2009 12:07 am

start loop activity will check for single row in a file(delimited)i.e 1,2,3
here i have to pass Number as One Parameter
Filename as Another Parameter.

In the file it contains multiple rows
how can i extract each row(two column Values) one by one in loop

sachin1 · Post by **sachin1** » Fri Mar 13, 2009 12:45 am

i think you need to read a file and in transformation you can do processing.

laknar · Post by **laknar** » Fri Mar 13, 2009 1:35 am

my design is

database--------file

from file i have to extract and pass into loop

ray.wurlod · Post by **ray.wurlod** » Fri Mar 13, 2009 1:43 am

I gave you a solution. All you need to do is purchase a premium membership so you can read it.

Premium membership is one of the ways that the hosting and bandwidth costs of DSXchange are met. It's not expensive, at less than 30c (Rs 12) per day, and there is an increasing set of benefits.