It is 2008 and I am sorry I posted in the wrong forum. I will try to run it as an administrator.

Thanks

I checked on my machine. I find Intelligence Development Studio icon and thru that only I tried to open the project and when I open a particular SSIS package it...

The administrator installed that. But recently the same question occured to me too. If you can tell me how I can check whether BIDS is installed quickly, it can help...

Try this :

select *

from blah

where

blah = blah

and blah = blah

and (

(@ActivityStatusID=1 and ACS.[Description] = 'Completed')

or

(@ActivityStatusID<>1 and ACS.[Description] <> 'Completed')

)