Ben Donley (![[info]](http://l-stat.livejournal.com/img/userinfo.gif){kind=small} dojothemouse) wrote,@ 2009-05-19 17:25:00 |
|
| Entry tags: | boring, broken |
More fun with SSIS deployment
So you're trying to deploy a SQL Server Integration Services package to a 2005 server, but you recently installed SQL Server 2008? Not behaving nicely?
I get this error, over and over again:
Full text:
TITLE: Package Installation WizardThanks, ass. It's NOT an earlier version! This is a 2005 package! It should be aces, right? Well, you think you're using the 2005 tools, but you're not. Your first clue that something is going wrong is here:
------------------------------
Could not save the package "C:\ss\SSIS\Control-Import GLPMF_CSH.root\Control-Import GLPMF_CSH\Control-Import GLPMF_CSH\bin\Deployment\Control Import GLPMF_CSH 2005.dtsx" to SQL Server "kci-marts".
------------------------------
ADDITIONAL INFORMATION:
Storing or modifying packages in SQL Server requires the SSIS runtime and database to be the same version. Storing packages in earlier versions is not supported.
------------------------------
BUTTONS:
OK
------------------------------
That's version 10, when you are supposed to be using the version 9 tools.
Here's what fixed it for me:
If you have any idea how to make this sensical (changing the path, as per this article, did nothing) to me, I would hugely appreciate that. Actually, if you can tell me how to fix the guts behind that "open with" menu in general, I will give you a little kiss.
