• I'm not an expert on this by any means, but IIRC, you have to create an identical table minus the columnstore index and use partition switching to 'switch in' the data to the table that has the columnstore index defined on it. The following link may help:

    http://social.technet.microsoft.com/wiki/contents/articles/5069.add-data-to-a-table-with-a-columnstore-index-using-partition-switching.aspx

    Regards

    Lempster