Depending on how many records, you could write a loop to push X at a time from the remote server to the main server.

You can also check if successful, and...

We've done the same way you're asking, but usually limit to only insert what doesn't already exist.

How many records? Will you be doing this more than once?

I usually try to avoid using week number, since a similar problem occurs at year end/begin.

Can you instead use the start date of the week? Monday for example?