Grant Fritchey (7/29/2014)
While you can connect to it, you won't be able to access 2014 objects and may run into issues with objects that contain 2014 only constructs (clustered columnstore).
I don't really see an issue when using SSIS 2012 to read/write from SQL Server 2014.
SSIS either issues just a select statement or it just sends data. How SQL 2014 handles it is of no concern for SSIS.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP