jhamilton 47458 (7/29/2014)
Our initial thoughts for considering SQL 2014 for the database was to take advantage of updateable columnstore indexes to enhance the performance of our ETL process. Are you saying that when SSIS 2012 is used to update a SQL 2014 database, you don't believe that we would take advantage of this 2014 feature?
Yes you can. SSIS will merely send some SQL statements to SQL Server which the database engine itself will execute.
SSIS does not care what SQL Server does behind the scenes.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP