its too big to post here..

takes 4 parameters-- one of them is a date..

what is parameter sniffing?

and how to resolve it?

Resolved...

Used a simple try catch block...

Thanks a lot anyways...

beats me...

if you are doing exactly what you are saying then thr is no reason it shud not work..

What is the datatype for the column contactname?

Check if your query is returning some data or not.

you need to do two things:

1) Modify your query as Select Top 1 contactname as GetName from contacts where contactname like 's%'

2)Change the 'ResultSet' property of your execute SQL task...

for a starter...you should replace the temp table(#table) by a table variable. That should help you.

Thanks

Pankaj