|
ZMike
Posting Yak Master
110 Posts |
 Posted - 10/31/2012 : 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 !
|
|
Package Migration Error from Version 6 to 3
