SSIS- find the Flat Files process

See more:

SQL-server-2000

SQL-Server-2005

, +

Hi,

In my package I have to use 5 flat file. 1) add 2) detail 3) dwr 4) npl 5) profession (text files). The DWR file will be used in the two different process in the same package.

steps

1) outer join between Add and Dwr

2) Outer join betwee Dwr and Detail

3) Outer join betwee npl and proffession

here if Dwr.txt is satify with add then its not merge with Detail else it merge with detail.

all files in the same dataflow. I can able to merge all the flat file but the problem is DWR. I have to show where it would be used at add process or at detail process.

I am new So please help me.