DSXchange

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.

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.

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

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

my design is

database--------file

from file i have to extract and pass into loop

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.