Also, I already have a script in place that adds a surrogate key to each row so that I can then split out the last row. Is there some...

At this point, I'm really open to anything. I guess my question would be how do I tell that I'm on the last row in order to write it...

Can you use the row count transformation, set the variable, and then use the value of the variable all within the same data flow task? I don't think you...

I got it working. I guess I had messed with the dataset and the stored procedure too much. I deleted the dataset and started over again and got...

The users would like the report to default to the correct week but then they still need to be able to choose other weeks.

When I create the dataset, should there...

The report that I created only includes the year and week. What I am wanting to do is to default that week parameter to the correct week for yesterday's...

That worked and I now see why that wasn't working. Thanks for the quick response.