Downgrading an ETL project from SSIS 2014 to SSIS 2012 - The version number in the package is not valid. The version number cannot be greater than current version number.

Question

Downgrading an ETL project from SSIS 2014 to SSIS 2012 - The version number in the package is not valid. The version number cannot be greater than current version number.

yrstruly

Hall of Fame

Points: 3440
More actions
August 30, 2016 at 12:28 pm

#400651

Hi
Can anybody assist me? These explanations(http://blog.haunschmid.name/downgrading-an-etl-project-from-ssis-2014-to-ssis-2012/#comment-3631 and http://connect.microsoft.com/SQLServer/feedbackdetail/view/944882/ssdt-bi-2014-backward-compatibility-for-ssis-2012) seems to be grate but does not say where do you find these files?

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply

prvmine SSCertifiable Points: 7006 More actions · Answer 1

not sure this will work since SSDT-BI 2013 is not backward-compatible with SQL Server 2012, but you might try the suggestions listed in the link below

https://vaniecastro.com/2015/02/26/how-to-downgrade-sql-server-integration-services-2014-packages-to-2012/

yrstruly Hall of Fame Points: 3440 More actions · Answer 2

Thanks, but i already have those links, that why i came on here for help. They don't say HOW and WHERE Do you find those files to be edited?

prvmine SSCertifiable Points: 7006 More actions · Answer 3

edit the dtxs files in a text editor

see attached for an example of the package path