Thanks Vinu, Actually I got it worked...I kind of did the same thing you suggested !

But thanks for the reponse !

I cretaed a stored procedure like this..

select

case when @Phonenumber in (select

cast(cast(PhoneNumber as bigint) as varchar(10))PhoneNumber

from dbo.DoNotCallList where PhoneNumber in ( select param from dbo.fn_MVParam(@Phonenumber,',')))

Then @Phonenumber

else @Phonenumber end...

I think I understood it correctly. If i were you I will enter file name each time it import to a separate table, and at the begining of the package...

If you don't mind can you send me the link

I tried to use merge join and its not giving the results as I needed..

and I am not so good at script to use script component...

Sorry ! heer I am attaching the word doc. Please let me know if this still cause the problem.