Apologies, I missed an important word out of my last post:

John

In that case, I would guess either that sqlmgmproviderxpsp2up.mof doesn't exist in the location specified, or that the.mof extension is recognised as that of an executable file.

John

Try this:"C:\Program Files\Microsoft SQL Server\110\Shared\sqlmgmproviderxpsp2up.mof"

John

Have you considered replication?

John

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. ...