HI Aamir Yes I am using Partial cache mode of lookup transformation My stored procedure has exactly the same statement as the end . And I gave the similar datatypes in the stored procedure . arun

Where are you saying to use CAST in lookup?arun

I am calling stored procedure in the lookup transformation by EXEC storedprocedure. But I am getting the error Paramererizes SQL Statement Yields metdata which doesn’t match the main SQL statement. I dont have datamode access true on the server . I can't use OPENQUERY . Can anyone has any other solution ?