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 ?

Hello Arun, I assume that you are using Partial Cache mode of Lookup Transformation? Your Stored procedure should have SELECT Statement at the end exactly same that you wrote when you start configuring Lookup. The metadata of columns should also match, you can use CAST Or CONVERT to change data type to your required format. Thanks http://sqlage.blogspot.com/

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

If your data types are same, then try to reconfigure again. But i remembered having this issue and Cast solved my issue. Thankshttp://sqlage.blogspot.com/

Where are you saying to use CAST in lookup?arun

CAST in the Select Statement you have at the end of Stored procedure. Thankshttp://sqlage.blogspot.com/