Thank you so much J. Drew Allen!  That is exactly what I was looking for.  I appreciate your help and detailed script.

Johnathan, thank you for your reply but that only yields two rows.

Here is the data -- I tried with the row_number() function and various other things that didn't work.  Any help is appreciated!

Table Data (view/query below this):

claim ID Claim status Rec...

Here is the data for the question:

I would try doing the insert in batches based on the primary key or another integer.  Create a while loop based off the key field and insert a smaller set...

You might want to use a script to update your variable values rather than use an expression since you are updating every time the package is run.

It sounds like the query you are running to merge into the table is returning duplicate rows.  The merge statement requires each row to be unique.

That would be very helpful.  Maybe I just don't know how to build the formula -- I keep getting errors.  I'm not much of an SSRS developer:)

Because the text box that should display the report title is not on a data regain, it is in the main report's page header.

Not that doesn't seem to work as the field is not visible to the main report.

There is a bookmark and when the bookmark is clicked the report shows.  The report is hidden or visible based on the bookmark value.  The funny thing is when we...

I figured it out.  It was the sizing of the body within the report.

Thank you!  That worked for me.

Thanks for the advice!

What we found is that one of the underlying tables used in one of the views the query uses had 20 million + rows. Rebuilding the indexes prior to...