There are two ways to update a table with Columnstore index in 2012:

i) The usual disable index - load data - rebuild index routine

ii) Efficiently use table partitioning to switch...

I can take this one.

As per comments for the post, there may be problems while working with files of 100MB or more. In our case, we frequently receive multi-GB files. Still, will try this...

The files coming in may belong to 4 different DTDs and can contain namespaces too. When I tried using XML source with DTDs, I faced issues. That is why.

Instead of the following statement, use the name of the current database where you want to create the SP.

USE [EMP_DETAILS]

GO

Then, in the remaining SP, wherever you are using table name,...

You should actually be troubleshooting why the SP wasnt automatically run every day when all others did.

If however, you still want to create this SP in another database, in...