Hi Champs/Satya I really need you guys help on this. I am new to DTS package and I have to create a DTS package of some thing of this kind. 1.Another server is writing the data to a ftp server.I have to read the data from ftp server and load it into a table. Uptil now it sounds fine. But before reading the data I have to check a condition whether data is prent on ftp server or not and if it is kept also then I have to give some looping condition to read the data as the data is kep in many number of events. Another problem is after reading the data I have to link the table with other table. Can you guys specially satya and all other guys throw some ideas on this. Thanks Allot for this help. I am in real need for this.