Dtexec error: The version number in the package is not val. Package migration from version 6 to version 3 failed with errorid

Error: I got the following error when I tried executing SSIS package from dtexec.

Microsoft (R) SQL Server Execute Package Utility

Version 10.0.2531.0 for 64-bit

Copyright (C) Microsoft Corp 1984-2005. All rights reserved.

Started: 8:10:18 AM

Error: 2012-10-10 08:10:18.97

Code: 0xC001700A

Source:

Description: The version number in the package is not valid. The version numb

er cannot be greater than current version number.

End Error

Error: 2012-10-10 08:10:18.98

Code: 0xC0016020

Source:

Description: Package migration from version 6 to version 3 failed with error

0xC001700A "The version number in the package is not valid. The version number c

annot be greater than current version number.".

End Error

Error: 2012-10-10 08:10:18.98

Code: 0xC0010018

Source:

Description: Error loading value "<DTS:Property xmlns:DTS="www.microsoft.com/

SqlServer/Dts" DTS:Name="PackageFormatVersion">6</DTS:Property>" from node "DTS:

Property".

End Error

Could not load package "ExecuteSql_Sample.dtsx" because of error 0xC0010014.

Description: The package failed to load due to error 0xC0010014 "One or more err

or occurred. There should be more specific errors preceding this one that explai

ns the details of the errors. This message is used as a return value from functi

ons that encounter errors.". This occurs when CPackage::LoadFromXML fails.

Source:

 

Solution:

This error happened because I developed the package using SqlServerDataTools (BIDS of 2012) and the error shows it is trying to downgrade to a lower version

Solution for this is to execute the dtsexec from the version that you developed it with. In my case it is Sql Server 2012, so the path of the dtexec that you need to use is C:\Program Files\Microsoft SQL Server\110\DTS\Binn. You can update the Path environment variable to move this to the foremost among other dtexec paths