July 6, 2011 at 4:34 pm
Hi All,
I have a lot of packages that were upgraded through the wizard from VS2005 to VS 2008. But, our DBAs haven't upgraded our Servers from SQL 2005 to SQL 2008 yet. When I sent them a package to deploy, they are getting a very generic error. I can run the package just fine from VS2008 which imports and massages data into our database.
When he deploys the package he gets the error:
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.". The occurs when CPackage::LoadFromXML
Any trick to deploying my packages without having to recreate all my changes into the old 2005 version?
Thanks!
July 6, 2011 at 5:57 pm
You cannot deploy a 2008 package to SSIS 2005. You will need to get SSIS 2008 installed in order to deploy those packages. This does not mean that the databases need to be upgraded to 2008, just that an Instance of SSIS 2008 needs to be out there for you to deploy. If you store your packages in msdb, you may also need to upgrade an instance of SQL server to 2008.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
July 6, 2011 at 6:40 pm
That's what I was afraid of. And, not knowing that, I have already migrated the packages and made 3 days work of coding changes. I supposed there is no way of converting the already converted package back to 2005?
July 6, 2011 at 9:40 pm
TecheeGirl (7/6/2011)
That's what I was afraid of. And, not knowing that, I have already migrated the packages and made 3 days work of coding changes. I supposed there is no way of converting the already converted package back to 2005?
No, not really. Changes to the underlying objects pretty much negated the ability to do that. I haven't heard of any successful way to reverse deploy a package that worked well.
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply