Three questions:

(1) Are payments to be applied in order of receipt number, so that the lowest-numbered receipt for any store gets paid first?
(2) In your required output,...

And the expected results based on that, please?

Edit: oops, ignore that!  Didn't see your update to your post before I posted.

Thanks
John

Write a CTE that numbers the rows, partitioned on the values of the single column, then delete from that CTE where the row number is greater than 1.

John

I would leave that to your presentation layer, if I were you.  Excel and SSRS will both present the data in the form you're looking for very easily.  What happens...

So is it OK now?  I can't explain why it happened.  At first I thought maybe it didn't upgrade all the components, but then I noticed that in the original...

This does everything in one go; from there you can create and/or populate your table accordingly.

DECLARE
     @RowCount bigint
,    @Schema sysname = 'TempTest'
,    @Table sysname...

Jonathan

What happens if you set the DelayValidation property of the connection manager to True?  If that doesn't work, you could set the connection string property with an expression...

That can't be the whole script.  I need to see everything, please, including where you're assigning values to those variables.  And you still haven't answered how you're actually doing this.  Don't...

Mmmm... not much good without the actual parameter values, I'm afraid!  But as Adi and Phil have suggested, try unduplicating those backslashes in your file path(s).

John