July 19, 2012 at 12:47 am
how to find if ssis packages was created with BIDS 2005 or BIDS 2008?
I have a package and whenever i try to run this package it give me error.
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.
July 19, 2012 at 1:01 am
In which version are you trying to run the package?
My guess is that you are trying to run 2008 packages in a 2005 environment.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
July 19, 2012 at 1:45 am
Yes i am running in 2005 environment.
But i need to confirm whether the package i am running is build using BIDS 2008, how i can find this?
July 19, 2012 at 2:27 am
If you look at the XML code behind the package, you'll see this for a 2008 package:
<DTS:Property DTS:Name="PackageFormatVersion">3</DTS:Property>
2005 has code 2.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
July 19, 2012 at 2:45 am
Thank uou very much. I see that it was created in 2008.
One more issue i have that there are some packages which were running fine earlier but now i am always getting the below error for each package.
Description: The package failed to load due to error 0xC0010014 "One or more error occurred. There should be more specific errors preceding this one that explains the details of the errors. This message is used as a return value from functions that encounter errors.". This occurs when CPackage::LoadFromXML fails.
Is someting got changes to the server or something else error.
July 19, 2012 at 2:51 am
Is this the only error? The message itself points out there should be more:
There should be more specific errors preceding this one that explains the details of the errors.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
July 19, 2012 at 3:39 am
Yes this is the only error.
July 19, 2012 at 3:43 am
Well, the only thing that makes sense is CPackage::LoadFromXML, which only pops up if a package cannot be opened for some reason, usually corruption.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
July 19, 2012 at 5:01 am
Thanks for reply. I got similar to this but still not able to find how to find
Project Properties, Debugging and setting Run64BitRuntime to false
The below url explain the same issue.
http://qa.sqlservercentral.com/Forums/Topic737169-148-1.aspx
July 19, 2012 at 5:06 am
Not sure that will work, but you need to right click on your SSIS project and select properties.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
July 19, 2012 at 5:33 am
Actually that is the issue,i am not able to open package through Visial studio version.
I am getting mscoree.dll error. As you stated earlier looks like all the packages got corrupted.
July 19, 2012 at 5:36 am
Are there packages that you still can open?
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
Viewing 12 posts - 1 through 11 (of 11 total)
You must be logged in to reply to this topic. Login to reply