Thank you so much this was very helpful

Thanks Gila and Paul.

So effectively I should consider more optimization of the query itself with an execution time of 55 secs ?

since 5 secs run time is only temporary run...

you can add a Script task to display the value at runtime using MessageBox.Show Method.

if the package doesnt like the value you are passing then its got to do with...

ok try this may be..

SET @sqlquery = 'DTExec "/DECRYPT TBRIAN2" /FILE "C:\MCG\SSIS\Medmas Import.dtsx"

/SET \Package\DataFlowTask.Variables[User::SvcDate].Value; '''+@SvcDate+''' ';

brian-594509 (5/31/2013)

---

I am getting the error "Argument ""\Package\DataFlowTask.Variables[User::SvcDate].Properties[Value];"" for option "set" is not valid." when i attempt to pass a parameter to a variable within a SSIS package.

The...

our database is not financial, our use of NOLOCK hint was to increase concurrency and limit contention (deadlock).

Thanks for all pointers..I will revisit the select Queries and data model in...

ok. Thanks for explaining that.

Thanks for your reply.

I think my post was bit confusing or I didnt explain it correctly.

I want to Stop sending messages to the local Queue that sends it to the...

Do you know the answer though ?

blocking is bad enough to raise alarm. but like I said its only when some service user tries to authenticate 100 times in few seconds.

update [dbo].table

set

LastModified = @utcnow,

LastModifiedBy ...

In SQL Server 2008 Activity Monitor , under Recent Expensive Queires

there is a PLAN COUNT column. It says 4 plan counts.

I would like to make it low or may be...

Gail

It turned out to be quite interesting in the end.

In my service broker queue activation proc there was a transaction

followed by bunch of if else statements

in one of the IF...

I tried this self join which seemed to work.

...

problem has come back, that 'UPDATE' is still running in the background blocking all the commands I run !