SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 SQL Server 2008 Forums
 SSIS and Import/Export (2008)
 Package Migration Error from Version 6 to 3
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

ZMike
Posting Yak Master

110 Posts

Posted - 10/31/2012 :  15:48:06  Show Profile  Reply with Quote
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 - 11/01/2012 :  11:01:37  Show Profile  Reply with Quote
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
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.12 seconds. Powered By: Snitz Forums 2000