January 19, 2017 at 11:40 pm
Hi,
I have ssis package on sql server 2008 which use "Transfer SQL Server Objects Task". It works fine when I am using to transfer database objects from one location to another with SQL SERVER 2008 database. When I am using this package to connect with sql server 2014 database it through Exception "Version120 database compatibility level is not supported". I set the compatibility level to 100 then its through Exception "Version100 database compatibility level is not supported". I am not sure that 2008 package will work with 2014 database or not? Can anyone help me how to resolve?. If I have to upgrade package then how and in which environment?
Thanks
January 20, 2017 at 3:14 am
A 2008 package will not work on 2014 no, as it's 3 version newer (2008R2, 2012, 2014). You'd need to do the opposite and create the package for and from 2014 and connect down to 2008.
Also, just to double check, what compatibility level is your database on 2008? Just because it's on a 2008 server, doesn't mean it's Compat 100 (I have a Compat 90 on our 2012 for example :pinch: ).
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
February 13, 2017 at 2:21 am
Thanks Thom,
It work for me by upgraded SSIS Package to 2014 and connect to 2008.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply