Home Forums Data Warehousing Integration Services SQL SERVER 2008 SSIS Package not working with sql server 2014 database RE: SQL SERVER 2008 SSIS Package not working with sql server 2014 database

  • 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