If you can identify the client by either the data in the file, or by the folder from which it came, yes, this can be done.   If you expect someone...

The basic problem here is that you were trying to use a column that was not participating in the INSERT.  Can't do that without using MERGE, and that does appear...

Here we go:
IF OBJECT_ID(N'tempdb..#StatusHistory', N'U') IS NOT NULL
    BEGIN;
    DROP TABLE #StatusHistory;
    END;

CREATE TABLE #StatusHistory (
    Status_History_Id int NOT NULL PRIMARY KEY CLUSTERED,
    [Status] tinyint NOT NULL,

I took your original posted code and integrated Jeffrey Williams ideas into it:
/********************************************

EXEC [cusVA_SEHMedicaidReconciliationReport]
@DATETYPE   = 'DOS'
, @STARTDATE  = N'01/01/2014'
,...

Replication in SQL Server just doesn't provide that kind of functionality.   It's entirely a one-way operation.   However, have you looked into high availability features?

You haven't really provided much in the way of detail.   All we know is that you use an SSIS package, with a container, and that there are 7 SQL tasks. ...

I guess I look at this differently.   Why would you ever expect such constructs NOT to affect the order?   NULL values would clearly cause the ordering to change, and whether...