Package Migration Error from Version 6 to 3

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2008 Forums

SSIS and Import/Export (2008)

Package Migration Error from Version 6 to 3

Author

Topic

ZMike
Posting Yak Master

110 Posts

Posted - 2012-10-31 : 15:48:06

I have a package that I need to be able to run from Task Scheduler and run on a machine instead of the Server due to some of the instances of my SSIS.

When I run this

DTEXEC.exe /F "M:\Visual Studio 2010 Projects\MIKE\Mail\Package.dtsx"

I get the log below.

Here is the log

Microsoft Windows [Version 6.1.7601]
Copyright (c) 2009 Microsoft Corporation. All rights reserved.

C:\Users\>DTEXEC.exe /F "M:\Visual Studio 2010 Projects\MIKE\Mail\Package.dtsx"
Microsoft (R) SQL Server Execute Package Utility
Version 10.50.2500.0 for 32-bit
Copyright (C) Microsoft Corporation 2010. All rights reserved.

Started: 3:37:45 PM
Error: 2012-10-31 15:37:45.36
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-31 15:37:45.36
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-31 15:37:45.36
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 "M:\Visual Studio 2010 Projects\MIKE\Mail\Package.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:
Started: 3:37:45 PM
Finished: 3:37:45 PM
Elapsed: 0.109 seconds

C:\Users\>

My issue is ** I think ** is that I downloaded SQL Server 2012 and built the SSIS in VS 2010 and maybe when it's seeing the package it's hitting one of the other SQL Servers installed on my machine. I currently have 2008 , 2008R2 and 2012. I did find this link

http://blogs.msdn.com/b/ramoji/archive/2008/12/24/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.aspx

But I could not figure out how to make this work.

I had tried this to no avail :

C:\Program Files\Microsoft SQL Server\110\DTS\Binn\DTEXEC.exe /F "M:\Visual Studio 2010 Projects\MIKE\Mail\Package.dtsx"

If anyone has any suggestions I'd greatly appriciate it !

ZMike
Posting Yak Master

110 Posts

Posted - 2012-11-01 : 11:01:37

I figured it out . For anyone having similar issues

cd "C:\Program Files\Microsoft SQL Server\110\DTS\Binn\"
DTEXEC.exe /F "M:\Visual Studio 2010 Projects\MIKE\Mail\Package.dtsx"
exit

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources