November 15, 2016 at 1:29 pm
Hello friends,
I am working on a project to upgrade a SQL Server instance from 2008 R2 to 2016. This server is also running SSIS 2008. Based on the MS documentation, it appears that different versions of SSIS can co-exist on the same server. I would like to take advantage of this by leaving SSIS 2008 in place, yet also installing SSIS 2016 side-by-side and slowly migrating the packages to the new version.
What I am unclear on is this:
Can an SSIS 2008 instance/package connect to a SQL 2016 database (or 2012 or 2014)?
I’ve seen a lot about backwards compatibility, but not forwards. Is anyone else doing this type of thing? Any help would be greatly appreciated. Thanks!
November 15, 2016 at 1:48 pm
Clint-525719 (11/15/2016)
...Can an SSIS 2008 instance/package connect to a SQL 2016 database (or 2012 or 2014)?
I have a computer still running SSIS 2008 R2 that runs packages against a SQL Server 2014 database on a daily basis. (using either OLEDB or ADO.Net connectors) As far as SSIS is concerned, it doesn't seem to mind at all.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply