locked
error - The version number in the package is not valid. The version number cannot be greater than current version number RRS feed

  • Question

  • whats does this error mean

    i download 2008 r2 and try to open package but still getting error

    Error 1 Error loading  The version number in the package is not valid. The version number cannot be greater than current version number.  
    Error 2 Error loading Package migration from version 8 to version 3 failed with error 0xC001700A "The version number in the package is not valid. The version number cannot be greater than current version number.".  


    • Edited by SSISJoostMVP Monday, February 2, 2015 7:20 AM Title too general
    Friday, January 30, 2015 6:49 PM

Answers

  • You are trying to open a package which was built in higher version but your current SSIS is lower version. Thus you get the error because there is no backword compatibility here.

    My guess is that the Package was built in BI 2014 and you are trying to open it in BI 2008.

    So build the package in 2008 version itself. Or open it in version 2014.

    Please find explanation by Katherine in below thread :

    https://social.msdn.microsoft.com/Forums/en-US/9ef06885-96c1-47e9-8746-ccb21f717dbb/problem-executing-ssis-packages-is-sql-server-2012?forum=sqlintegrationservices


    -Vaibhav Chaudhari


    Friday, January 30, 2015 7:07 PM
  • getting following error :

    Started:  2:02:13 PM
    Error: 2015-01-30 14:02:14.68
       Code: 0xC000F427
       Source: Member Eligibility
       Description: To run a SSIS package outside of SQL Server Data Tools you must
    install Member Eligibility of Integration Services or higher.
    End Error
    Warning: 2015-01-30 14:02:14.69
       Code: 0x80019002

    You have some SSIS Task - "Member Eligibility" which makes package fails because I guess the server which you use in DTEXEC has no Integration Services Installed.

    Please re-try after installting Integration Services.



    -Vaibhav Chaudhari

    Friday, January 30, 2015 7:45 PM

All replies

  • Looks like older version is picked up ! you can give full path of DTEXEC. Also you can give a try to upgrade package !
    Friday, January 30, 2015 7:00 PM
  • can you tell me which version it is >

    i try to fix in dtexec

    getting following error :

    Started:  2:02:13 PM
    Error: 2015-01-30 14:02:14.68
       Code: 0xC000F427
       Source: Member Eligibility
       Description: To run a SSIS package outside of SQL Server Data Tools you must
    install Member Eligibility of Integration Services or higher.
    End Error
    Warning: 2015-01-30 14:02:14.69
       Code: 0x80019002

     Description: SSIS Warning Code DTS_W_MAXIMUMERRORCOUNTREACHED.  The Execution
     method succeeded, but the number of errors raised (2) reached the maximum allow
    ed (1); resulting in failure. This occurs when the number of errors reaches the
    number specified in MaximumErrorCount. Change the MaximumErrorCount or fix the e
    rrors.
    End Warning
    DTExec: The package execution returned DTSER_FAILURE (1).
    Started:  2:02:13 PM
    Finished: 2:02:14 PM

    i cannot upgrade original package

    Friday, January 30, 2015 7:06 PM
  • You are trying to open a package which was built in higher version but your current SSIS is lower version. Thus you get the error because there is no backword compatibility here.

    My guess is that the Package was built in BI 2014 and you are trying to open it in BI 2008.

    So build the package in 2008 version itself. Or open it in version 2014.

    Please find explanation by Katherine in below thread :

    https://social.msdn.microsoft.com/Forums/en-US/9ef06885-96c1-47e9-8746-ccb21f717dbb/problem-executing-ssis-packages-is-sql-server-2012?forum=sqlintegrationservices


    -Vaibhav Chaudhari


    Friday, January 30, 2015 7:07 PM
  • getting following error :

    Started:  2:02:13 PM
    Error: 2015-01-30 14:02:14.68
       Code: 0xC000F427
       Source: Member Eligibility
       Description: To run a SSIS package outside of SQL Server Data Tools you must
    install Member Eligibility of Integration Services or higher.
    End Error
    Warning: 2015-01-30 14:02:14.69
       Code: 0x80019002

    You have some SSIS Task - "Member Eligibility" which makes package fails because I guess the server which you use in DTEXEC has no Integration Services Installed.

    Please re-try after installting Integration Services.



    -Vaibhav Chaudhari

    Friday, January 30, 2015 7:45 PM
  • I have the same issue.. i am using SSDT 2013 and on server SSDT 2013 is installed but database is SQL server 2008, what should i do to make it work?
    Thursday, December 10, 2015 4:33 PM