error

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.".  

January 30th, 2015 9:49pm

Looks like older version is picked up ! you can give full path of DTEXEC. Also you can give a try to upgrade package !
Free Windows Admin Tool Kit Click here and download it now
January 30th, 2015 10:00pm

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

January 30th, 2015 10:06pm

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=sqlintegrationservic

January 30th, 2015 10:07pm

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 Ser

January 30th, 2015 10:45pm

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics