command line ssis package execution error
hello all,
i created my first (awsome) ssis project and now time to execute it thru command line.
i developed in vs 2008 and works great. i also executed it thru "execute package utility", selected the source as a file and executed it, works great.
now, time to run it thru command line, i picked the command line from "execute package utility" and get the following error:-
Started: 10:33:38 AM
Error: 2010-11-16 10:33:41.96
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: 2010-11-16 10:33:41.96
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 c
annot be greater than current version number.".
End Error
Error: 2010-11-16 10:33:41.96
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 "p:\VS 2008\SSIS Projects\EFT.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: 10:33:38 AM
Finished: 10:33:41 AM
Elapsed: 3.203 seconds
mark it as answer if it answered your question :)
November 16th, 2010 1:47pm
Follwoing might help you
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
Gaurav Gupta http://sqlservermsbiblog.blogspot.com/
Free Windows Admin Tool Kit Click here and download it now
November 16th, 2010 4:01pm