SSIS error: version number in the package is not valid

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2008 » SQL Server Newbies » SSIS error: version number in the package is...

SSIS error: version number in the package is not valid

Rate Topic

Display Mode

Topic Options

Author

Message

J M-314995

Posted Friday, February 22, 2013 9:48 AM

SSC Journeyman

Group: General Forum Members
Last Login: Wednesday, March 20, 2013 11:21 AM
Points: 83, Visits: 259

I installed SSIS 2008 (SSIS, SSRS, SSAS....not the database engine) on a server that already had SQL Server 2005 installed that also had SSIS/SSRS.

I used BIDS 2008 to create an SSIS package, opened up SSMS 2008 which looks at the 2005 server engine to add/schedule a Job in the Agent to launch the SSIS 2008 package. I'm guessing this won't work because it's a SQL Server 2005 instance? Or is there a way to force the SQL Server Agent job use the C:\Program Files\Microsoft SQL Server\100\DTS\Binn\DTExec.exe instead of the one here...C:\Program Files\Microsoft SQL Server\90\DTS\Binn\DTExec.exe ???

The error I'm getting when I run the package is...

Execute Package Utility Version 9.00.5000.00 for 32-bit Copyright (C) Microsoft Corp 1984-2005. All rights reserved. Started: 8:55:33 AM Error: 2013-02-22 08:55:34.03 Code: 0xC001700A Source: Description: The version number in the package is not valid. The version number cannot be greater than current version number. End Error Error: 2013-02-22 08:55:34.03 Code: 0xC0016020 Source: Description: Package migration from version 3 to version 2 failed with error 0xC001700A "The version number in the package is not valid. The version number cannot be greater than current version number.". End Error Error: 2013-02-22 08:55:34.03 Code: 0xC0010018 Source: Description: Error loading value "<DTS:Property xmlns:DTS="www.microsoft.com/SqlServer/Dts" DTS:Name="PackageFormatVersion">3</DTS:Property>" from node "DTS:Property". End Error Could not load package "E:\2008\logixhealth\logix.dtsx" because of error 0xC0. The step failed.

Post #1423138

Adam Angelini

Posted Tuesday, February 26, 2013 3:58 PM

Ten Centuries

Group: General Forum Members
Last Login: Yesterday @ 8:27 AM
Points: 1,084, Visits: 808

Edit the job step and choose operating system (cmdExec) instead of SQL Server Integration Services Package. Then set your command line to something like this:

C:\Program Files\Microsoft SQL Server\100\DTS\Binn\DTExec.exe /F "c:\packagepath\packagename.dtsx"

Your package must be saved in the filesystem in order to do this.

Post #1424271

« Prev Topic | Next Topic »

Permissions