I think the merits of this approach depend on the details. Obviously, if you create a temp table, then insert data into it via a join, then query the...

Thanks again, SQLRNNR. I think the link you posted is very cool. Someday I will need to create an SSIS package that downloads all the reports.

Thanks Alex,...

Thanks for the speedy replies. The problem seems to be that I am not in Report Manager. I've just asked someone I work with how to get there.

I...

Jeff, BTW, I really enjoy your avatar. I could probably spend the whole day admiring it. 🙂

Hi Jack, thanks for the clarification. I changed my logic and found a different way to pass in a parameter to the package allowing me to operate on a...

OK, the problem is that I had a disabled task that was also connected to the same Foreach container. I have been trying to change my package so that...

It is simple enough to have a column in a SQL statement that represents the current date. You can even simplify the SQL statement to just return the current...

I learned that it is best to use OLEDB as the source for the Data Flow task that fills the spreadsheet via the Excel Destination task. This may seem...

Thanks, a4apple. During the course of trying to get it to work I had parameter mapping in the Execute SQL task as well as a result set. I...

Has your colleague looked at the "Execution Results" pane for a clue about what is happening? Are there any errors?

Another thing to try is have your colleague rebuild the...

Thanks, Phil. I now see the error of my ways! 🙂

Thanks, Eirikur Eiriksson. I've got it going. I appreciate the help!

Once again the table won't populate. I wonder how Microsoft can get away releasing something as buggy as Report Designer. I have spent a day and half over...

Well, suddenly it works. I created another stored procedure that was a skeleton of what I need. In the "Data" pane I changed the dataset's reference to this...

Visibility of the detail row of the table in question is set with Hidden = false. The same setting is for both detail columns. Same with the table...