Your question is quite vague. Sample data, DDL, and what you want as a final result is going to help here.

What is the logic for showing/not showing the tablix? is it purely based on it there are rows in the dataset? If so, you can simply set the visibility of...

wendy elizabeth (12/1/2016)

---

You definitely are on the correct path! However if I want domain user testdomain/testuser to have access that has been user within the entire database for that user,...

Ok. That's a good start. What your reasoning for choosing to do this via SSIS? I asked as send dbmail is very good at achieving this, especially as your data...

Welsh Corgi (12/1/2016)

---

Thom A (12/1/2016)

---

All you've asked is "How do you get all the rows...

All you've asked is "How do you get all the rows from a table in...

AS Luis said, you don't need an execute, you need a dataflow. Place a dataflow task on your contro,l flow, open it up. Place an OLE DB source, and an...

That article there is talking about returning a single row and then inserting those values into variables. Is that your aim here? Your title says that you want to put...

I tend do use the RIGHT function. For example, we have something called "branches" which should be displayed as two digit integer values. Therefore, if I need then ensure branches...

1) SSRS can return any data you really ask it to. It can be the entire contents of Table, a Stored procedure, or SQL. If you're running SQL in the...

Have a look at this article[/url].

This is quite a vague question, and solutions can vary depending on what you're doing and where the data is coming from. Could you give a little more information about...

declare @str varchar(max)=''

select @str=@str+'exec [dbo].[usptest]' + ' '''+abc.name+'''; '

from abc

exec(@str)

There isn't a loop in the SQL you've given us here. Your code will simply concatenate your strings, and then EXECs...

robert.wiglesworth (11/29/2016)

---

Thanks Luis, I thought of that too, but didn't really want to do that because it still has to load the whole large table. Unfortunately, I don't have access...

Like I asked before, can we please get some DDL and sample data? This would really make things a lot easier. Could you perhaps give a more detailed explanation of...