Aaron N. Cutshall (12/5/2016)
The team did identify a method of pushing the data to SQL Server but this approach requires coordinating the stored procedure execution on SQL Server to occur AFTER the data push. I was hoping to avoid such a scheduling/dependency nightmare by having it all coordinated within the SQL Server SP, but I may have to take a different approach. Of course, if this were 2016, we'd have Polybase at our disposal...
Why wouldn't a trigger do it for you? For that matter, why couldn't Hadoop call a batch file that fires off SQLCMD?
--Jeff Moden
Change is inevitable... Change for the better is not.