The problem is its erroring out when I try to select this variable in Command from Variable in OLEDB source and I cannot bypass this mesage to watch the value...

I changed it to like this..Still no luck

"SELECT col1, col2 FROM vw_my_view

WHERE [" + @[User::SqlFilter] + "]"

Thanks for your reply. I am getting there.

Now, what i did was, since my source sql was very big, I created a view for it. So I declare two variables.

One...

Thanks for the explanation. I am still having some confusion and I am hoping that I would be explain it lil better.

I have a column called SQlFilter in my setup...

No. I can't do that. This some body else's process. I just need to be able to create that stored proc. How about creating this under the service account?

I am familiar with ssis. How ca I accomplish this through ssis?

So, do I need to create sp with OPENROWSET?

Thanks. But I need somthing that is currently executing and it is executing longer than 15 second. Not the ones which aare done execution.

SSC veteran, that worked. Thanks for your help. BTW, it didn't require a reboot.

Thanks again!!!!

Yes. This is error logged in windows when I reattempt to start agent.

SQLServerAgent could not be started (reason: SQLServerAgent must be able to connect to SQLServer as SysAdmin,

but '(Unknown)'...