No. It's still a result set, not a scalar value, even if your result set happens to have only one row and one column. Use Parameter Mapping instead.

John

Not quite sure what your requirement is here, but you could try joining your table to grupyTowarowe on materialGroup = grupa.

John

Are you using the Result Set page? If so, don't - it's for result sets, not scalar values. Use Parameter Mapping instead.

John

The answer is in the error message. You can't use an aggregate function ([font="Courier New"]SUM[/font]) on an expression containing a subquery ([font="Courier New"]SELECT grupa FROM grupyTowarowe WHERE typ LIKE...

If you're editing your package in BIDS or SSDT then the value shown will be the value at design time, not the value at run time. Do you have...

Vin

This might work. It should if you're running a statement(s) that doesn't already have a cached plan. I'm not sure what will happen if you're running one that...

Not with the data you've posted, it doesn't. I'm guessing the reason you get the error is that you're running the query against one or more rows that don't...

Something like this?SELECT

c.session_id

,t.text

FROM sys.dm_exec_connections c

CROSS APPLY sys.dm_exec_sql_text(c.most_recent_sql_handle) t

John

Use sp_configure. I think there's also a catalog view, called something like sys.configurations, that you can query directly.

John

Backup, restore, change compatibility level to 100, remove old users, create new ones.

John

Voldemar, you're mixing up variables and parameters. If you want to use a variable, build up the SQL statement in the variable outside of the data flow task. ...

Luis Cazares (7/11/2016)

Mohit Dhiman (7/11/2016)

Can't see why this should not work. Which version of SSIS...

Miguel

Get sp_whoisactive and run it when you see the blocking. That'll tell you who or what is doing it, and you can ask or force them to disconnect.

John

Mid-morning for me, Jeff. Easier to think when you've been awake for a few hours!

John

Unless you upgrade to SQL Server 2016 and use the Query Store, you're not going to be able to get what you're looking for with total accuracy. You can...