开发者

SQL Server 2008 SSIS package compatability

开发者 https://www.devze.com 2022-12-12 01:22 出处:网络
I am trying to save an SSIS package on a sql server running 2005. The issue I have is that I am using SQL Server Man开发者_StackOverflow中文版agement Studio 2008 on my local machine to do this and it

I am trying to save an SSIS package on a sql server running 2005. The issue I have is that I am using SQL Server Man开发者_StackOverflow中文版agement Studio 2008 on my local machine to do this and it won't let me save the package in on the server because its not compatible with 2008. Is their some kind of compatibility option in management studio that I don't know about?


The short answer is no: the 2005 and 2008 package formats are different, and 2008 packages can't be downgraded to 2005.

The best solution is probably just to install the 2005 tools alongside the 2008 ones and use them for designing your packages.

0

精彩评论

暂无评论...
验证码 换一张
取 消