This might not be the most elegant way to do it but it seems to have worked for me whenever I encountered this same problem.

I prefer to write a stored...

Excellent question!  I've always believed understanding the fundamentals is the only way to REALLY understand what you are working with.

DG

When you assign a property through a dynamic properties task, the query you create must return only one value.  It it returns a result set, only the value of the first...

Here are the details of the trace i set up:

1)Sql Profiler client is being run from/on same server containing the database

2)Log to database table

3) Only EventClass chosen is TSQL-SQL:BatchStarting

4)LoginName like 'the user'

5)ApplicationName...

Thanks Tom,

Sorry I did not mention it but I have tried this approach already and have unfortunately experienced performances issues.  I believe I have set up my filters to be...

Thanks Frank.  I was trying to avoid dynamic sql myself but that looks like the route I have to take.  Thanks everyone for their help.

Thanks for the suggestion.  That is how I originally wrote the query but unfortunately in my real-life case the variable that @name corresponds to has about 18 different possibilities (not...

Thanks for the reply.  I changed my code to:

/***************************************/

DECLARE @Name varchar(30), @Firstname varchar(30), @ID varchar

SET @Name = 'y' -- 'y' = get info by firstname, 'n' = get info by...